> > 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 =
> Sent: 25 October 2004 11:37
> To: Ian Firla
> Cc: Steve McGill; [EMAIL PROTECTED]
> Subject: Re: [PHP] Most efficient way of fetching 1,000 records from
> MySQL ?
>
>
> Ian Firla wrote:
> > I think you'll find that your first approach is not only more correct,
&
Ian Firla wrote:
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 =
sq
I think you'll find that your first approach is not only more correct,
it's the only manageable one.
Ian
On Mon, 2004-10-25 at 10:15 +0200, Steve McGill wrote:
> Hello,
>
> In my script I have generated an array of 1,000 userIDs for example. Now for
> I need to fetch each user's record and I am
Hello,
In my script I have generated an array of 1,000 userIDs for example. Now for
I need to fetch each user's record and I am wondering what is the best way
to go about it:
1) 1000 sql queries
// code is sort of pseudo for clarity
foreach($users as $userID) {
$user = sql("select * from user
5 matches
Mail list logo