Martijn Tonies wrote:

>Roman, others,
>
>
>Doesn't it make more sense to get a useful query cache?
>
>If FIRST n SKIP m from some largish resultset is what you're asking
>for several times in a row, why isn't the largish resultset cached?
>
>What should indices have to do with sorting? Yes, I know they're used
>sometimes to do the job, but if you're getting several "pages" of rows
>(not datapages) doesn't a good cache make more sense?
>
>
>

Martijn,

That's what I tried to say.. :-) I think you expressed it better than
me... A "Cached Result Set". I think it's too close to a Cursor...

Let's hear what the people says about it.. if it's possible or just
bring more problems that it solves.

>With regards,
>
>Martijn Tonies
>Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
>Server
>Upscene Productions
>http://www.upscene.com
>
>

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.1/28 - Release Date: 24/06/2005