Posted by Bent Stigsen on 07/18/06 23:30

Mladen Gogala wrote:
> Is there such a thing? I need a good pager for Oracle RDBMS which will
> not re-execute the same query gazillion times. In order to do that, I
> plan on writing query results to a file and then map the file to an
> array. In order for the whole thing to work reasonably fast, I need
> something similar to mmap - therefore the question. I need to map large
> chunk of disk space to memory and do it fast. Any ideas?

Is the Oracle off limits? I mean, having/creating tables for the
temporary query result, which you subsequently select from. You'll
need to clean up at some point afterwards, but I reckon you need some
mechanism for that anyway.

--
/Bent

[Back to original message]