Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

executemany is very slow #60

Open
GoogleCodeExporter opened this issue Mar 15, 2015 · 0 comments
Open

executemany is very slow #60

GoogleCodeExporter opened this issue Mar 15, 2015 · 0 comments

Comments

@GoogleCodeExporter
Copy link

What steps will reproduce the problem?
1. Use executemany with a list of query parameters.

What is the expected output? What do you see instead?
I'd expect the parameters to be bound and a single SQLExecute call be made.

Instead it calls execute for each query parameter, which binds and calls 
SQLExecute.

When inserting many of records, this makes a huge difference.

What version of the product are you using? On what operating system?
Version 1.3.3 on Linux.


Please provide any additional information below.
I'm no expert on ODBC but ceODBC does this, if I understood their code 
correctly, and it's immensely faster.

Original issue reported on code.google.com by javier.r...@gmail.com on 15 Jan 2015 at 7:08

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant