0

i m searching a record from database. and it contain more than 10lac records. it take lot of time and some times mysql got crashed. how i can reduce searching time..?? does xml will be helpful in this case.?

4
Contributors
6
Replies
7
Views
7 Years
Discussion Span
Last Post by sam023
0

Check the overhead of your table.. sometimes if could get a bit large if you're constantly creating/deleting things.

0

Also optimise your queries - do you need to run a query inside a loop of another query or can you use JOIN, also do you have primary keys defined.

Do you place LIMITS on results so that you only query the records you require?

All of these and more can help - google optimising MySQL queries.

Also I read that sorting etc is 4000% faster in PHP than in MySQL.

0

it is just a simple select query to search whether a mobile number exit or not... but searching criteria is very large..its more than 10lac.

Edited by sam023: n/a

0

how to reduce time while searching

Jump out of a deep gravity well, this should speed things up quite nicely.

0

i got the solution through indexing.. thanks anyway

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.