sql speed
Ruslan Zasukhin
sunshine at public.kherson.ua
Sun Feb 27 11:11:09 CST 2005
On 2/27/05 2:55 AM, "jda" <jda at his.com> wrote:
> Hi Ruslan,
>
> I have put together a method of joining cursors by storing recIDs of
> individual searches in arrays, and then either ANDing or ORing the
> arrays (in RB). I then do a final search using the recIDs that are in
> the final array. As a result, there can be thousands of numbers. I
> find that the search is actually pretty slow, no doubt due to the sql
> overhead. For the search below, for about 2800 recIDs, it takes a
> about 7 seconds. I wonder if there is something new in V2 that would
> speed this up (I still need a cursor at the end of the operation).
> Thanks.
Hi Jon,
New is sub-select (actually form that you need was in the 1.x also).
Select
>From T1
WHERE recid in (select recid from T2 .... )
--
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-beta
mailing list