MySQL Forums
Forum List  »  InnoDB

Re: optimized searching - need desperate help
Posted by: Ankur Saxena
Date: July 02, 2005 04:45PM

Hi Jay,

Thank you so much, it did the trick. The indexing was the one which solved the problem. I am not very familiar with indexing, but how do I decide to make index or not. This is really helpful, infact the query was responding in 0.00 sec, which is phenominal, now I have 1.1 million records and still the response, even if it is in the .1 sec range I am happy.

Again how do I find more about optimizing my Database designs for the type of queries I perform. Like in this case you mentioned the index, can you suggest some place where I can do a quick read.

Also I dont need to recreate indexes right, once done any amount of data I put in will always be indexed. Also how does it really help to index and what are the negatives of index?

Thanks
Ankur

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: optimized searching - need desperate help
2046
July 02, 2005 04:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.