Hello everyone,
I am starting this thread to start the discussion of "Database Optimization", in hopes of improving performance.
We have a database with 20 million+ locations, and query responses have been slowing down. I want to improve that using indices and other database optimization techniques and would like to hear what everyone has successfully tried and tested so far.
I'm using SQLServer, but a lot of the concepts can be used for other db servers for everyone to benefit.
Thank you,
Awni
All the required indexes are already implemented. 20 millions is not a big number for a properly configured SQL database. If queries are slowing down it probably means that your database engine is running out of resources, or misconfigured.
Hello everyone,
I am starting this thread to start the discussion of "Database Optimization", in hopes of improving performance.
We have a database with 20 million+ locations, and query responses have been slowing down. I want to improve that using indices and other database optimization techniques and would like to hear what everyone has successfully tried and tested so far.
I'm using SQLServer, but a lot of the concepts can be used for other db servers for everyone to benefit.
Thank you,
Awni