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