I meant queries that get run each time through a loop ie, query for a resultset, then loop through the resultset and run another query for each row. I see that kind of thing over and over again in these forums, and in live websites. Likewise the 'select *' then bung it into an array and sort/filter/merge/search for specific data, all of which could have been done with a single well-constructed query. As it sez in the manual, sql is 10 to 20 times faster than code IN ANY LANGUAGE when it comes to dealing with large recordsets.

The thing I find hard to understand is the number of excellent coders who can't get their heads around JOINS?? They can astound me with their mastery of regular-expressions, make arrays jump through hoops, and yet cannot grasp just what is going on with a left join. Go figure?