On Mar 9, 12:02 pm, "Adrian Maier" <[EMAIL PROTECTED]> wrote:
> On 3/9/07, AD7six <[EMAIL PROTECTED]> wrote:
>
>
>
> > > Are there better ways to fetch the query result one by one ?
>
> > Why do you want to, what is the goal you want to achieve?
>
> In short: I'm reading the tuples from table T1, and for each tuple i'm
> searching for corresponding tuple in table T2 and , if neccessary, update
> some fields of T2 according to the current tuple of T1.
>
> Sometimes, if there are enough records in T1, my action reaches
> PHP's maximum memory limit. I haven't researched to see exactly
> what is the number of records when the memory gets filled (but was
> less than 15000 records).
Why isn't all this logic in the db? I think you'd be better off
showing what you are doing rather than describing it ;).
HTH,
AD
>
> What i want is to fetch the query results one by one, because in this
> case i really don't need the array with all the records.
>
> --
> Adrian Maier
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---