sql speed

[Ruslan Zasukhin]

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.

And I think we need to profile this query.
    we can use viSQL for this.

So we need query and database for tests

-- 
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
-------------------------------------------------------------