>>preocedure is really slow, it takes up to 15 minutes to retrieve 90 records from a database that has 54000.
>
>Unless U are using a 386 This procedure should not take that long! I hope you have all fields indexed. A genreal rule of thumb is to build and index on any field to the left of the "=" sign in your SQL Where clause. Even concatonated strings. Readup on optimatiztion of RUSHMORE technology for additional details or check this thread. I remember seeing something along time ago about this stuff... Cheers...
I finally find it and I think is going to work.
What I have in mind is to split the SQL statement in pieces and then submit as many SQLs as I need and then
add everything, got it ?.
Anyway thanks a lot.
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould