Hi Christian,
Which is it? Local or remote? If it's a local DBF, there's no way SPT or ADO will speed it up; good indexing will. If it's remote, you could have the query execute through a stored procedure on the server side and simply pass the result set back ... way, way faster.
>I have a table containing 1 500 000 rows. When I make a query on it, it takes long time to execute. Is there a way to speed up the query by using indexes or by execute it asynchronously (SPT, or ADO). My 1,5M rows table is local.
>
>Thank you,
>Christian
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05