Hi Thomas,

Thanks for your message....
I just spent 30 minutes on the internet to search try to understand
your suggestion...
How do I define a passthrough query in ASP with mySQL?

However, even if the passthrough query works, and this will be very
interesting for me to learn, it still doesn't explain how all of a
sudden the speed of the application plunged; and what I can do about it
to fix it....

Thanks!

> Try defining a PassThrough query that will bypass all the MS libraries and
> speak directly to the MySQL server. All you want is to have the server
> execute a sql statement and deliver the results to an ADO or DAO recordset
> object. PassThrough queries bypass most of ADO to achieve this.