Performance/Benchmark questions

[eluser]xwero[/eluser]
For the sql question, i think it depends more on how are you going to use the information than on what is the fastest way.

If the only information you want to know is the row count you are better off with COUNT in the sql statement. If you are after the field values you can always do a check to see how many rows there are in the result if it's needed.