>>
>>... The query takes considerable time...
>>
>
>I recently had the same problem. In my case there were memo fields in a larger table and the query took too long. The memo-Fields where not part of the "order by" or any filter-Options, just cargo. I ended up splitting the query into two queries which speeded up the whole thing a lot.
>
>
>select TOP 10 ID ;
> from XY ;
> where ...
> order by;
> into cursor JUNK
>
>select A.* from XY A inner join JUNK B;
> on A.ID = B.ID;
> into cursor RESULT
>
Frank,
I also have a memo field so I guess your approach should speed up the query. The only issue is that I am calling the query from ASP.NET page and I have to figure out how to do 2 select statements instead of one. I don't know how or if it is possible to do it.
Thank you so much for your suggestion.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham