On 5/3/2016 12:06 AM, Michael Torrie wrote:
Now if you want to talk about processing the data once you have it, there we can talk about speeds and optimization.
Be glad to. Helps me learn python, so bring whatever challenge you want and I'll try to keep up.
One small comparison I was able to make was VBA vs python/pyodbc to summarize an Access database. Not quite a fair test, but interesting nonetheless.
--------------------------------------------------- Access 2003 file Access 2003 VBA code 2,099,101 rows 114 tables (max row = 600288) 971 columns text: 503 boolean: 4 numeric: 351 date-time: 108 binary: 5 309 indexes (25 foreign keys) 333,549,568 bytes on disk Time: 0.18 seconds --------------------------------------------------- same Access 2003 file 32-bit python 2.7.11 + 32-bit pyodbc 3.0.6 2,099,101 rows 114 tables (max row = 600288) 971 columns text: 503 numeric: 351 date-time: 108 binary: 5 boolean: 4 309 indexes (foreign keys na via ODBC*) 333,549,568 bytes on disk Time: 0.49 seconds * the Access ODBC driver doesn't support the SQLForeignKeys function --------------------------------------------------- -- https://mail.python.org/mailman/listinfo/python-list
