general query questions

[eluser]xwero[/eluser]
It's a good practice to only query the database for the things you need. The more data gets put in the memory the faster the memory limit will be exceeded.

The AR library is slow because it generates the query for you. It's the same thing with everything you let php generate for you. So it's up to you whether you are going to use AR or not.