Skip to content
This repository has been archived by the owner on Oct 4, 2024. It is now read-only.

Latest commit

 

History

History
25 lines (19 loc) · 757 Bytes

README.md

File metadata and controls

25 lines (19 loc) · 757 Bytes

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