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