[jToolkit-cvs] jToolkit/data PyADO.py,1.7,1.8

[<dav...@us...>]

Update of /cvsroot/jtoolkit/jToolkit/data
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv12982

Modified Files:
	PyADO.py 
Log Message:
added a simple speed test (users will need to change connect details and sql statement)
useful for optimisations



Index: PyADO.py
===================================================================
RCS file: /cvsroot/jtoolkit/jToolkit/data/PyADO.py,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** PyADO.py	9 Feb 2004 14:04:47 -0000	1.7
--- PyADO.py	9 Feb 2004 14:18:50 -0000	1.8
***************
*** 403,407 ****
--- 403,433 ----
      theConnection.close()
  
+ def speedtest():
+     import time
+     import ADOProviders
+     start = time.time()
+     conn = connect(None, user="ameriven", password="ameriven", host="", provider=ADOProviders.OracleProvider)
+     curs = conn.cursor()
+     connected = time.time()
+     curs.execute("select * from categorylists")
+     executed1 = time.time()
+     curs.fetchall()
+     fetched1 = time.time()
+     curs.execute("select * from categorylists")
+     executed2 = time.time()
+     curs.fetchall()
+     fetched2 = time.time()
+     conn.close()
+     print """connect:   %0.3f
+ executed1: %0.3f
+ fetched1:  %0.3f
+ executed2: %0.3f
+ fetched2:  %0.3f""" % (-start+connected, -connected+executed1, -executed1+fetched1, -fetched1+executed2, -executed2+fetched2)
+ 
  if __name__ == '__main__':
+     import sys
+     if '--speedtest' in sys.argv:
+         speedtest()
+         sys.exit()
      #database = 'C:\\Documents and Settings\\Administrator\\Desktop\\db1.mdb'    
      #sql = 'select * from jobs'