On 3/9/07, phirschybar <[EMAIL PROTECTED]> wrote: > > findAll($conditions = null, $fields = null, $order = null, $limit = > null, $page = 1, $recursive = null); > > You can specify the fields you want to return, along with conditions, > limits, just like any basic query.
I am aware that i can select only some of the fields My issue is that find / findAll : - reads all the matching the records from the table - stores all the values in memory - returns a reference to that array Let's exaggerate and assume that there are 20 million tuples in the table: findAll will create an array with 20 million elements , even if i specify only 2 of the table's fields . I'd like to : - issue a query - while (are records left in the query result) : get next record and process it In this case only the array containing the current record would be generated, therefore I could process millions of records without needing them stored in memory. -- 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 [email protected] 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 -~----------~----~----~----~------~----~------~--~---
