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.?
sam023
0
Junior Poster
Recommended Answers
Jump to PostCheck the overhead of your table.. sometimes if could get a bit large if you're constantly creating/deleting things.
Jump to PostAlso 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 …
All 6 Replies
Encrypted
0
Junior Poster in Training
liamfriel
4
Junior Poster
sam023
0
Junior Poster
liamfriel
4
Junior Poster
diafol
sam023
0
Junior Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.