Re: Most efficient way of fetching 1,000 records from MySQL ?
| From: | Steve McGill | Date: | Mon, 25 Oct 2004 11:43:56 +0000 |
| Subject: | Re: Most efficient way of fetching 1,000 records from MySQL ? | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-200235@lists.php.net to get a copy of this message | ||
> > I think you'll find that your first approach is not only more correct,
> > it's the only manageable one.
>
> No, it will be very slow. The biggest overhead is in transfering data to
> and from sql server. It's always better to get the results in one sql
query.
>
> Use this aproach:
>
> $users =
> sql('select * from users where userID IN ('. implode(', ',$users)
> .')');
That is precisely what I wanted, many thanks for your help guys.
Steve