"DB Nightmare: Slow Queries on Big Dataset - Need Help Optimizing!"

[Schwezow]

"Hey guys, I'm at my wit's end trying to optimize performance on a database for my crypto project. We're talking millions of rows of historical trading data and query times are just ridiculous (we're talking hours to pull a simple table). Anyone have a magic solution or some tips on indexing, caching, or scaling?"

 

[MickleSon]

"Dude, have you checked your indexing and fragmentation? If your queries are slow, it's probably because the DB is doing a full table scan, which is a major performance killer. Can you share more about the schema and queries you're running?"

 

[rttg999]

"Hey guys, have you considered indexing your tables? I had a similar issue and adding the right indexes made a huge difference. Might be worth checking your schema and seeing if there are any other optimizations you can squeeze out of it."

 

[keen01]

"Hey OP, what's the DB engine and schema like? Are you running any indexing or have you checked for any deadlocks? Maybe a query plan would help us diagnose the issue"

 

[heushgxkhuik]

Discussion: strategies