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

SHP

New member
Joined
May 24, 2008
Messages
3
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
1
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
2
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?"
 
Top