matlab-sqlite3-driver icon indicating copy to clipboard operation
matlab-sqlite3-driver copied to clipboard

Time issue when selecting several columns

Open florentmathieu opened this issue 6 years ago • 2 comments

Hello,

first thank you for this great work, the API is really easy to use and it's a pleasure the I'm now able to extract data from my colleagues' files without asking them to export to csv...

I noticed that the time needed to extract several columns at a time was more than the time needed to extract these columns separately. In my case, if I extract 6 columns at a time it takes me about 1.2 seconds, and if I extract 6 times 1 column it takes 0.4 seconds overall. In the end it can make quite a difference.

It's not a problem to do that for me, it's just a little bit less convenient and pretty to copy/paste the SELECT line. Is this something related to sqlite or to your API ?

Best,

Florent

florentmathieu avatar Dec 14 '17 16:12 florentmathieu