Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199903

Re: [PHP3] 10 query results at a time... From: Ayman Haidar (haidar <email protected>)
Date: 03/08/99

try

SELECT * FROM tbl_test where (id=x) LIMIT 10;

Ayman

Thus spake Sam Goin (samgoin <email protected>):

> Thanks. Does anybody have an example script for getting 10 results at a
> time?
>
> Thanks,
>
> Sam Goin
>
>
> -----Original Message-----
> From: Daniel Lashua <daniel.lashua <email protected>>
> To: Sam Goin <samgoin <email protected>>
> Cc: php3 <email protected> <php3 <email protected>>
> Date: Monday, March 08, 1999 10:09 AM
> Subject: Re: [PHP3] 10 query results at a time...
>
>
> >Well... depends on.... faster overall would be to get all the records
> >and have PHP parse them... however, the initial request will take longer
> >than the small 10 row requests would take. So... are you looking for
> >overall speed, or speed in between each page? If you don't mind having
> >your users wait a while for the first request, it is probably best to
> >get it all at once, and throw it in a flat file or in shared memory or
> >something, and then retrieve it piece by piece as needed.
> >
> >Daniel
> >
> >
> >Sam Goin wrote:
> >>
> >> Hello,
> >>
> >> I have 2 questions.
> >>
> >> 1. Would it be faster for the client to get a semi-large query result,
> and
> >> then use php3 to display 10 rows from the result at a time, or would it
> be
> >> faster to query the database 10 rows at a time?
> >>
> >> I am using Apache 1.3.4 and MySQL. The results from each row would be
> less
> >> than 15 KB, and the total result would be no more than 300 rows.
> >>
> >> 2. Can you give me an example code for the answer to #1?
> >>
> >> Thanks,
> >>
> >> Sam Goin
> >>
> >> --
> >> PHP 3 Mailing List http://www.php.net/
> >> To unsubscribe send an empty message to php3-unsubscribe <email protected>
> >> To subscribe to the digest list: php3-digest-subscribe <email protected>
> >> For help: php3-help <email protected> Archive:
> http://www.php.net/mailsearch.php3
> >> List administrator: zeev-list-admin <email protected>
> >
>
>
> --
> PHP 3 Mailing List http://www.php.net/
> To unsubscribe send an empty message to php3-unsubscribe <email protected>
> To subscribe to the digest list: php3-digest-subscribe <email protected>
> For help: php3-help <email protected> Archive: http://www.php.net/mailsearch.php3
> List administrator: zeev-list-admin <email protected>
>
> 

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3
List administrator:  zeev-list-admin <email protected>