But VB6 is faster then VFP8 too. VB6(5sec) run almost 2x of the speed of VFP(10sec). (.NET is slowest 13sec)


vb6 code

strsql = "SELECT wo.id,wo.po,wo.custPo,wo.custPo1,wo.iCusId," & _
"share.ppl.no, FROM erp.wo LEFT JOIN share.ppl ON wo.iCusId = share.ppl.id " & _
"WHERE wo.comp = 0"
rs.CursorLocation = adUseClient
text1.text = now
rs.open strsql, sqlconn, adOpenForwardOnly, adLockReadOnly
text2.text = now



Just wonder how VB6 can acheive.


TIA.