search

memsql / memsql-python

This repository holds some python libraries and plugins designed to be used with MemSQL.
MIT License
62 stars 33 forks source link

Switch to store_result for performance #4

Closed carlsverre closed 8 years ago

carlsverre commented 8 years ago

Going to let travis-ci check this out. Found a issue with _mysql in which use_result grows the result buffer by 1000 rows each time. This causes perf issues when the number of rows returned is much larger than 1000.

carlsverre commented 8 years ago

You can see the linear buffer growth here: https://github.com/farcepest/MySQLdb1/blob/master/_mysql.c#L1609