I try using SQLEXEC to retrive MYSQL data, it take me 10 sec. It is so slow compare to SQLyog or MYSQL-Front, It take only 3-5 sec. In VB it take about 6 sec.

Does any way to improve the speed of SQLEXEC? I try to set the PacketSize, but it does not affect the speed.

TIA.

Here is my prg :


mSql = 'SELECT wo.id,wo.po,wo.custPo,wo.custPo1,wo.iCusId,ppl.no FROM erp.wo LEFT JOIN share.ppl ON wo.iCusId = share.ppl.id'

mTime1 = DATETIME()
SQLEXEC(oSql.connECTHANDLE2,mSql,'cmasc')
mTime2 = DATETIME()
MESSAGEBOX(mTime1)
MESSAGEBOX(mTime2)