sql speed

[Ruslan Zasukhin]

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

>>>  Select * from T1 WHERE 1,4,6,12,14... in (select recid from T1)
>> 
>> No, how you get original list of recIDs?
>> 
>> Using some SQL query ?
>> 
> 
> Hi Ruslan,
> 
> Yes, something like this:
> 
> select RecID from thereferences where (left(allFields, 3)='the')

Excellent, so solution is:


select id,hit,uniqueID,authors,thedate,title,editors,authorsSortMethod
from thereferences 
where RecID in
        ( select RecID from thereferences where (left(allFields, 3)='the'))


> I do 1...n queries, after each one adding to an array of integers
> (recids). I make sure there are no duplicates. At the end, I have the
> recids of all the records I want to retrieve (this way I can make an
> AND or OR of multiple searches). It is quite fast.
> 
> When I'd done, I want to create a cursor (containing many fields,
> sorted) of the recids.

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