Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
2.0.13
-
None
-
None
-
None
-
Windows 64-bit
Description
MariaDB ODBC driver performance gets degraded drastically when array size (SQL_ATTR_ROWSET_SIZE) is reduced to 1000 or less. For example, to fetch 500K records (3 columns):
SQL_ATTR_ROWSET_SIZE: 100000, took 4.8 seconds
SQL_ATTR_ROWSET_SIZE: 10000, took 5 seconds
SQL_ATTR_ROWSET_SIZE: 1000, took 8.7 seconds
*SQL_ATTR_ROWSET_SIZE: 100, took 55 seconds
SQL_ATTR_ROWSET_SIZE: 10, took 516 seconds (that's close to 9 mins!)*
If I compare same with MySQL 5.3.7 ODBC driver,
7.3 sec, 6.5 sec, 6.6 sec, 6.8 sec, 8.2 sec respectively, which is fairly working.
I don't think table schema really matters, but this is what I've:
mysql> desc sampleTable2;
---------------------------------------------------------------------------+
Field | Type | Null | Key | Default | Extra |
---------------------------------------------------------------------------+
COL_INT | int(11) | YES | NULL | ||
COL_CHAR250 | char(250) | YES | NULL | ||
COL_TIMESTAMP | timestamp | NO | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
---------------------------------------------------------------------------+