How many records your query returns?

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