MySQL Forums
Forum List  »  Connector/ODBC

ADO & MySQL Overhead ?
Posted by: Jay Alverson
Date: November 14, 2008 06:42PM

I have a MySQL Databse v5.0 and I hooked up a Winbatch script to it via ADO.

The table has 492 records and I selected just the TEXT field from each to loop thru the records and give me the biggest sized record.

I want to make sure I can put the entire text into a Winbatch Array item.

So I ran it and it sat there, and sat there and sat there. 2.18 minutes later it came back with 89,640 characters as the largest entry.

I thought this was a Winbatch overhead issue, so I wrote the same exact script in VBScript and 2.16 minutes later it returned with the same data.

I have an MS Access table with MEMO fields, ran more or less the same script on it, 1104 records came back in 3 seconds with 10,109 characters the largest.

Is this a symptom of MySQL setup ? (I'm pretty new to it).

Any insight is appreciated.


Well just for grins I took MS Access and linked to MySQL table via ODBC and using the linked connection, the ADO script returns in 3 seconds.

Must be an ADO-->MySQL overhead thing.


Thanks, Jay

Options: ReplyQuote

Written By
ADO & MySQL Overhead ?
November 14, 2008 06:42PM
November 17, 2008 09:03AM
December 04, 2008 11:36AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.