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