Jai Prakash

21 reputation

	21 reputation	bio	website		visits	member for	8 months
1 badges		location	Melbourne, Australia		seen	Oct 25 '12 at 3:56

4 Actions

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