On 22 Jan 2010, at 16:31, Volkan Varol wrote:
> Hello precious and brilliant minds,
>
> I would like to know if there's a better way (syntactical or logical) to
> achieve a better performance for the scenario below:
>
> Let's say we have any kind of query with a LIMIT and an OFFSET (used to
>
On 22/01/2010 15:31, Volkan Varol wrote:
[snip]
> my scenario this is unavoidable since I require it, but there may be a
> trick to reduce its overall cost.
>
> The only alternative solution I've come up with so far is to save row
> counts into the table itself using triggers. Is this reasonable o
Hello precious and brilliant minds,
I would like to know if there's a better way (syntactical or logical) to
achieve a better performance for the scenario below:
Let's say we have any kind of query with a LIMIT and an OFFSET (used to
limit/offset rows displayed on the web page). For example:
QUE
