running 4.x MySQL is very slow to return a large result set of about 45,000 records. The query seems to execute in a few seconds, but then it takes another 90 seconds to return all the data.
The same query only takes 6 seconds to execute and return on MSSQL server, so I must have something setup wrong ( <- MySQL newbie ) I am using MyCC to issue the query. I already tried increasing the key_buffer_size and some other varaibles. here is the create: CREATE TABLE `tbl_PO_MainDetail` ( `nItemID` int(11) NOT NULL default '0', `sPOID` varchar(50) NOT NULL default '', `nNum` smallint(6) NOT NULL default '0', `sJobID` varchar(50) NOT NULL default '', `sItemID` varchar(30) NOT NULL default '', `nMatlID` int(11) NOT NULL default '0', `sDescription` varchar(250) NOT NULL default '', `sUnits` char(3) NOT NULL default '', `sMatlSize` varchar(10) NOT NULL default '', `nMatlTypeID` int(11) NOT NULL default '0', `sMatlShape` varchar(10) NOT NULL default '', `sMatlAlloy` varchar(15) NOT NULL default '', `dMatlQtyBars` double NOT NULL default '0', `dMatlQtyBarsRec` double default NULL, `dMatlQtyBarsDue` double default NULL, `dMatlLength` double default NULL, `sOperation` varchar(50) NOT NULL default '', `sRev` varchar(9) NOT NULL default '', `dQty` double NOT NULL default '0', `dQtyRec` double NOT NULL default '0', `dQtySent` double NOT NULL default '0', `dQtyDue` double default NULL, `dQtyToRec` double NOT NULL default '0', `dQtyToRecEA` double NOT NULL default '0', `dQtyToRecUnit` double NOT NULL default '0', `dQtyToRecBars` double NOT NULL default '0', `dPrice` double NOT NULL default '0', `yTaxable` tinyint(1) NOT NULL default '0', `dExt` double NOT NULL default '0', `dExtTax` double NOT NULL default '0', `nGLAccountID_Expense` int(11) NOT NULL default '0', `sGLExpenseIDX` varchar(50) NOT NULL default '', `dOpNum` double NOT NULL default '0', `dFPP` double NOT NULL default '0', `nEmpID_For` int(11) NOT NULL default '0', `bBarNoBreak` tinyint(3) unsigned default NULL, `upsize_ts` varchar(16) NOT NULL default '', PRIMARY KEY (`nItemID`), KEY `FK_tbl_PO_Main` (`sPOID`), KEY `_WA_Sys_dPrice_398D8EEE` (`dPrice`) ) TYPE=MyISAM; --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
