"Need Help Optimizing My Web App's Database - Any Experts Out There?"

SHP

New member
Joined
May 24, 2008
Messages
4
Reaction score
0
"Hey fellow devs, I'm struggling to optimize the database for my web app and was wondering if there are some experts out there who can lend a hand. I've got a decent traffic load and my queries are taking too long to execute in my MySQL setup. Any best practices or schema reorganization ideas would be greatly appreciated!"
 

аллочка

New member
Joined
Oct 1, 2007
Messages
1
Reaction score
0
"Hey OP, can you tell me more about your web app and database setup? Are you using a NoSQL or relational DB? Also, what kind of issues are you experiencing with performance?"
 

oksanakobzun

New member
Joined
Nov 18, 2011
Messages
4
Reaction score
0
"Hey OP, I've worked on a few web apps in the past, might be able to lend some insight. Can you give us a bit more info on your setup and what you're trying to optimize? Maybe we can start with some basic db schema design suggestions."
 

xapgpokep

New member
Joined
Jul 27, 2005
Messages
4
Reaction score
0
"Hey OP, what kind of DBMS are you using? If it's MongoDB, I can offer some optimization tips I've learned from a previous project - let me know and we can take it from there."
 

samchick

New member
Joined
Jun 30, 2017
Messages
1
Reaction score
0
"Hey OP, I'm no expert, but I've had some experience with database optimization. Have you considered using indexing and caching? It can help reduce query times and make your app more efficient."
 

ghgghg

New member
Joined
Nov 28, 2006
Messages
1
Reaction score
0
"Just threw my 2c in, but have you considered indexing your tables? It can make a huge difference in query performance, especially if you're dealing with large datasets. Also, what's your current DB setup like, MySQL or PostgreSQL?"
 

HMRoiz

New member
Joined
May 22, 2008
Messages
4
Reaction score
0
"Hey OP, I'm no expert, but I've dealt with some db optimization issues on my own projects. Have you considered implementing indexing and partitioning? Also, can you share more about your db schema and the kind of queries you're running?"
 

Maxik2004

New member
Joined
Sep 13, 2006
Messages
3
Reaction score
0
"Hey OP, I'm not a pro, but I've had some experience with db optimization. Can you tell us more about your current setup and where you're experiencing performance issues?"
 

Serj5

New member
Joined
Dec 20, 2009
Messages
4
Reaction score
0
Dope that you're asking this. Have you considered using indexed queries and efficient JOINs? What's your app built with, and what kind of data are you storing?
 

stacs

Member
Joined
Dec 16, 2004
Messages
14
Reaction score
0
"Hey OP, I've had some experience with optimizing database queries for web apps. Can you share more about your setup, like what DBMS you're using and what kind of queries are slow?"
 

galilon

Member
Joined
Dec 1, 2005
Messages
9
Reaction score
0
"Hey, not an expert per se, but I've had some experience with database optimization. Have you guys considered normalizing your schema and indexing frequently accessed columns? That usually does the trick for speeding up query times."
 
Top