Database Query Performance
Discussions center on challenges with slow database queries in large datasets, optimization techniques like indexing and query restructuring, and debates over bottlenecks such as IO limits, CPU usage, and whether computations should be handled inside or outside the database.
Activity Over Time
Top Contributors
Keywords
Sample Comments
There's nothing to complain about with this. But aren't most large database queries ultimately IO capped, rather than CPU capped? Wouldn't this just put more load on the IO and it would just bottleneck there?
Wouldn't this drastically increase database latency?
Might be because it requires more complex database querying and/or is less cacheable.
Sounds like a pain for larger databases.
This is about the complexity of queries (which, without knowing your system, may be unbound) - rate limiting will not help.
please show these 50x faster queries. really. i am curious.
What're some DB query performance issues you've run across in the past and how did you resolve them?
It's really slow compared to normal SQL databases
Are you running a relational database? if so check all of your indexing. Unless you are doing some pretty crazy stuff indexing should reduce those queries to milliseconds.
There are potentially two problems:Your database's query optimizer sucks, orThe overhead is of object inflation, not a slow SQL query.