[eluser]WanWizard[/eluser]
Your reading all results into memory. Since every record is an object, this can consume lots of memory if you have a lot of records in the result set.
In general:
- if you need the results to iterate over them (like with a foreach), use get_iterated() instead of get() (see the manual).
- if you don't need all these individual results, rethink your query. Lots of rows in a result is an indication of a sub-optimal query.
