Page 1 of 1

Any idea to handle volume records?

Posted: Mon May 03, 2010 8:38 pm
by hgison
Dears,

I'm a beginner of PHP.
As we know, if the browsers receive volume amount of records will cause poor performance.
Do we have any tips to handle volume records?

thanks,
hgison

Re: Any idea to handle volume records?

Posted: Mon May 03, 2010 10:57 pm
by a94060
It sounds like you are referring to what value to paginate at? It seems that sites I have seen around either let you choose it,or make it some value like 50 if its just text, maybe less if there are pictures and such.

Re: Any idea to handle volume records?

Posted: Wed May 05, 2010 8:32 pm
by hgison
yea.... cause sometimes more than thousands records will return to user, it make the browser hang few minutes.
Generally, how we handle this problem?

Re: Any idea to handle volume records?

Posted: Thu May 06, 2010 2:18 am
by Weirdan
hgison wrote:yea.... cause sometimes more than thousands records will return to user, it make the browser hang few minutes.
Generally, how we handle this problem?
By not returning a thousand records at once?

Re: Any idea to handle volume records?

Posted: Sun May 09, 2010 8:25 pm
by hgison
yup, is it possible not return thousands records at once?
or measure the records volume, if its is more than 10 thousands records then pop up a waring window while user submit the request

Re: Any idea to handle volume records?

Posted: Mon May 10, 2010 8:43 am
by mikosiko
look for the LIMIT Mysql clause