Victor Spång Arthursson wrote:
> Ciao!
>
> Is it possible to get the number of rows that would have been returned
> if the LIMIT-clause weren't present in some way after the query was run?
>
> Reason for asking is that I have a really big chunk of SQL, which takes
> time to execute, and whoose result is paginated using a LIMIT- clause,
> and to get the actual result (before pagination) I have to run the
> query one more time… Big slow down…
No. Standard procedure here is to select the results to a temporary
table, or application-level cache etc.
--
Richard Huxton
Archonet Ltd