|
|
Posted by Bent Stigsen on 07/19/06 07:17
Mladen Gogala wrote:
> On Wed, 19 Jul 2006 01:30:03 +0200, Bent Stigsen wrote:
>
>> Is the Oracle off limits? I mean, having/creating tables for the
>> temporary query result,
>
> No, Oracle isn't off limits.
>
>> 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.
>
> Problem with paging in Oracle is this: if you want to page the output of
> a query, you have to execute it over and over again and discard all except
> the few rows. That's wasteful and slow.
Doesn't need to be like that. You could:
insert into cache_table select 'unique id' "_qid", rownum "_row",
....huge slow query...;
then then select on "_qid" and "_row" afterwards.
If they are indexed, Oracle should give what you need quite fast, and
shouldn't subsequently require much disc-io even if the result set is
humongous. It should be fast enough, I would think.
> Trick to do that would be to
> open a temporary file and map it to memory as an array. My question is: is
> there a way to do mmap in PHP5? Thanks to anyone who might help me with an
> answer.
Sorry can't help you there.
Not the same, but from the description of the apc extension, sounds
like you could use its apc-store and fetch.
--
/Bent
Navigation:
[Reply to this message]
|