Any idea to handle volume records?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
hgison
Forum Newbie
Posts: 3
Joined: Mon May 03, 2010 8:32 pm

Any idea to handle volume records?

Post 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
User avatar
a94060
Forum Regular
Posts: 543
Joined: Fri Feb 10, 2006 4:53 pm

Re: Any idea to handle volume records?

Post 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.
hgison
Forum Newbie
Posts: 3
Joined: Mon May 03, 2010 8:32 pm

Re: Any idea to handle volume records?

Post 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?
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Re: Any idea to handle volume records?

Post 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?
hgison
Forum Newbie
Posts: 3
Joined: Mon May 03, 2010 8:32 pm

Re: Any idea to handle volume records?

Post 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
mikosiko
Forum Regular
Posts: 757
Joined: Wed Jan 13, 2010 7:22 pm

Re: Any idea to handle volume records?

Post by mikosiko »

look for the LIMIT Mysql clause
Post Reply