21 reputation
1
bio website
location Melbourne, Australia
age
visits member for 2 years, 1 month
seen Oct 25 '12 at 3:56

Oct
2
comment help required with indexing and query optimzation
I have five years worth of data. Currently depending on the number of countries or for a world wide view the query executes some where between 40 seconds to 80 seconds. My accomplishment is certainly to reduce the query execution time.
Oct
2
comment help required with indexing and query optimzation
Thanks Rick for your comments. The table under question is gets regular inserts and frequent reads. So i was investigating if i can optimize the query in any way and decrease the query response time. I created new indexes as per your suggestion except for the world wide data (country_code >= 0) all the queries are running at much better now. I have one more doubt, is there any performance impact comparing signed and unsigned integers.
Sep
28
awarded  Student
Sep
28
asked help required with indexing and query optimzation