By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,275 Members | 947 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,275 IT Pros & Developers. It's quick & easy.

how to reduce(decrease) query execution time

100+
P: 121
hello friends,

I need some solution for reducing the query execution time.

Let me explain briefly:

I have 5000 records in mysql database. actually i am using browse buttons to see the records. i,e forward, backward and fastforward etc.. if i press forward button it will show one record in their respective text field.

so my problem is if i submit forward button it's taking more time to load values in the text box, and one more i already indexded all fields in the mysql table.

if total record no is less i.e (1-100) it was not taking much time to show records.

finally how i can reduce this execution time. please let me know.

thank u
Mar 15 '08 #1
Share this Question
Share on Google+
3 Replies


ronverdonk
Expert 2.5K+
P: 4,258
When you setup and read just one row each time, that of course will cost resources. It is cheaper to read all rows in one select into some sort of cache or your own storage storage and browse the result set.


Ronald
Mar 15 '08 #2

100+
P: 121
Thanks for the reply,

Mr. Ronald I did not get your points, please explain me in briefly.
Mar 19 '08 #3

ronverdonk
Expert 2.5K+
P: 4,258
I mean that by reading the entire row set into storage (only 5000 rows) you browse hence and forth through storage arrays and you don't have to physically read a table row each time you go forward or backward.

Show your code here (and do it within code tags!) and we will discuss any possible improvements in your query times.

Ronald
Mar 19 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.