On Wed, 20 Sep 2006 00:13:12 -0700, vanwout wrote:

> 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?

I know nothing of ASP. You must be using the Microsoft DAO or ADODB
libaralibraries. When you initiate your database or connection object,
you have the opportunity to add a dbSQLPassthrough switch that indicates
you want the system to pass the raw query through and let the the server
interpret the SQL and return the result set.

One trick I have resorted to is to use MS Access (.mdb) files. You can
create stored queries tagged as PassThrough. From there you can just
treat it like an ordinary Access database. The SQL in the query will
simply be sent to the server without interpretation by Microsoft and you
get the results back in a recordset. You can even dynamically alter the
SQL inside the querydef objects (in the Access .mdb file!), throwing
different MySQL legal queries into it. This is *mucho mas* faster that
letting ADO interact with MySQL directly.

> 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;

That's a question for Microsoft.

> and what I can do about it
> to fix it....

In my case, I have found the solution in falling back to older ADO library
..dll(s) and blocking automated Microsoft updates.

This is not wonderful. The more viable, long term solution for me is to
abandon attempts to mix Microsoft with non-Microsoft technologies (such as
MySQL). For me this means Microsoft gets the boot. I can't deal with
building my stuff on foundations of loose sand.

Sour grapes aside. You would probably get better results and better
responsiveness from Microsoft if you stick with all Microsoft technology
like SQL server or whatever the heck it is they push nowadays.

Thomas Bartkus



> 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.