Here is create table def:
CREATE TABLE `tblmainupdateinfo` (
`MainID` int(11) unsigned NOT NULL default '0',
`ClientID` int(11) unsigned NOT NULL default '0',
`UpdateInfo` tinyint(4) unsigned NOT NULL default '0',
PRIMARY KEY (`MainID`,`ClientID`),
KEY `ClientID` (`ClientID`)
) ENGINE=MyISAM
The first query shown in the log is the one I actually tells ADO.Open to run...
however just after that one it runs two more (the
two tables includes in the first query) select * queries... Why??
This slows down the ADO a lot. Even Jet4.0 doesn't do that on the same query and is
therefore about
