Skip to content

dirkjonker/cyodbc

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

cyodbc

Cython ODBC library

Very incomplete and very incompatible with ODBC and/or Python DBAPI 2.0

Might never be compatible with anything

Use at own risk and everything

Currently it only supports executing a simple SELECT statement without any parameters. Primary goal is to be very fast with fetching lots of rows, especially if you set cursor.arraysize to a reasonable amount such as 100 before you run cursor.execute()

SELECT 20,000 rows with 10 columns of different column types (varchar, int, bigint, double) from a MySQL server running on localhost, with cursor.arraysize set to 100:

pyodbc
average time (of 10 runs): 3.5033s
ceODBC
average time (of 10 runs): 0.0647s
cyodbc
average time (of 10 runs): 0.0649s

About

Cython ODBC library

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published