sql speed

[Ruslan Zasukhin]

On 2/27/05 11:51 AM, "jda" <jda at his.com> wrote:

>> select id,hit,uniqueID,authors,thedate,title,editors,authorsSortMethod
>> from thereferences
>> where RecID in
>>         ( select RecID from thereferences where (left(allFields, 3)='the'))
>> 
> 
> No. You don't understand (or I don't). That is only one search. I do
> MANY searches in a loop, after each one adding to my integer array
> (or recids). That way I can AND or OR many searches myself.
> 
> When I am finished I want to turn that array of recids I have made
> into a cursor.

Aha, many searches....
Then your way probably the only for SQL.

And we need improve that query I think.
It must be very fast.

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