It appears that ADO is significantly faster than SPT. Below code is just an example how I compared the performance:
time1 = SECONDS()
oConn = CREATEOBJECT("adodb.connection")
oConn.Open("bbfsdsn","sa","")
oCustomerRS = CREATEOBJECT("adodb.recordset")
oCustomerRS.Open("SELECT * FROM patledger",oconn)
time2 = SECONDS()WAIT WINDOW STR(time2-time1,10,2) && SHOWS 91.10 seconds
Time1 = SECONDS()
oConn = SQLCONNECT("BBFSDSN","sa","")
cSQL = SQLEXEC(oConn,"SELECT * FROM patledger","oCustomerRS")
TIME2 = SECONDS()WAIT WINDOW STR(time2-time1,10,2) && SHOWS 208.17 seconds
BTW, patledger table contains 650,500 records.
Any additional facts that confirms this is very much appreciated.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
