which way is faster?

[Anon]

Is there the differences about time between a SELECT query that results n records and n SELECT queries that result one record at a time but total still n record? The resulted records in both cases are the same.

[Anon]

Generally speaking, performing one query is going to be faster than multiple queries, due to only one command being executed, one connection being established, etc. I have found it is almost always more efficient to do things in as few queries as possible. (There can be exceptions to this rule, with more complex queries.)

[Anon]

You can use a CURSOR to get what you want. You perform a single query and then you just ask it to return a single result, then say the next 10 results and then the previous 5 resutls, etc.

Of course, MySQL doesn't support this - use Postgres.

Chris