Creating temporary table
Ruslan Zasukhin
sunshine at public.kherson.ua
Wed Dec 10 01:28:20 CST 2003
on 12/10/03 1:19 AM, jda at jda at his.com wrote:
>>> I guess I should wait until 2.0 to implement this, because it sounds
>>> like it will be easier and more efficient...
>>
>> But I wonder, why right now you can't just recreate cursor 1 ?
>>
>> I think Valentina will do this fast.
>>
>
> Funny you should ask -- I was going to explore saving the query and
> adding/subtracting to it and just requerying the database (until 2.0
> comes out). It will probably be fast enough (although not as fast as
> subsearching a cursor I would think).
NOT A FACT!
I have explain, that Cursor will NOT have indexes!
So it is not a fact that search on cursor will be faster,
May be only if table is huge but selection is small.
--
Best regards,
Ruslan Zasukhin [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com
To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------
More information about the Valentina
mailing list