8000 Possible pluggable C extension for performance by kesmit13 · Pull Request #1066 · PyMySQL/PyMySQL · GitHub
[go: up one dir, main page]
Skip to content

Possible pluggable C extension for performance #1066

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.

Sign up for GitHub

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

Draft
wants to merge 15 commits into
base: main
Choose a base branch
from
Draft

Possible pluggable C extension for performance #1066

Changes from 1 commit
Commits
Show all changes
15 commits
Select commit Hold shift + click to select a range
1d2021f
Add accelerator
kesmit13 Aug 24, 2022
655e858
Remove extra file
kesmit13 Aug 24, 2022
37b003d
Continuing unbuffered refactoring
kesmit13 Aug 26, 2022
622396f
Small cleanup of df buffer and output object
kesmit13 Aug 26, 2022
5d6ff13
Fix issues with numpy / dataframe memory
kesmit13 Aug 30, 2022
5827589
Doc cleanup and new license
kesmit13 Aug 30, 2022
0b8bb34
Merge branch 'PyMySQL:main' into main
kesmit13 Aug 30, 2022
76d6767
Add mysql exception to connection
kesmit13 Aug 30, 2022
d56ad06
Merge branch 'main' of github.com:singlestore-labs/PyMySQLsv
kesmit13 Aug 30, 2022
7b22cd6
More performance improvements
kesmit13 Sep 1, 2022
ea0ae59
Remove numpy support for now; clean up API
kesmit13 Sep 1, 2022
8e0fdd9
Fix formatting
kesmit13 Sep 1, 2022
e134133
Make invalid value replacements more generic
kesmit13 Sep 1, 2022
3b97395
Merge branch 'PyMySQL:main' into main
kesmit13 Nov 17, 2022
14c993c
Update README.md
kesmit13 Jan 9, 2023
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
Fix formatting
  • Loading branch information
@kesmit13
kesmit13 committed Sep 1, 2022
commit 8e0fdd98a94b3bef31be59304d46e6fc7684f1f3
12 changes: 6 additions & 6 deletions README.md
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -33,12 +33,12 @@ Here are the results.

| | PyMySQL | MySQLdb | PyMySQLsv |
|--------------------------|---------|---------|-----------|
| Buffered fetchone | 224.8s | 50.6s | 19.9s |
| Buffered fetchmany(20) | 217.63s | 50.3s | 15.5s |
| Buffered fetchall | 217.9s | 49.6s | 14.8s |
| Unbuffered fetchone | 230.5s | 48.3s | 25.3s |
| Unbuffered fetchmany(20) | 224.0s | 35.0s | 14.6s |
| Unbuffered fetchall | 232.4s | 37.7s | 29.2s |
| Buffered fetchone | 224.8s | 50.6s | 19.9s |
| Buffered fetchmany(20) | 217.6s | 50.3s | 15.5s |
| Buffered fetchall | 217.9s | 49.6s | 14.8s |
| Unbuffered fetchone | 230.5s | 48.3s | 25.3s |
| Unbuffered fetchmany(20) | 224.0s | 35.0s | 14.6s |
| Unbuffered fetchall | 232.4s | 37.7s | 29.2s |

As you can see the gains are quite significant for this test case. Even MySQLdb,
which is based on the MySQL libraries takes twice as long in all but one
Expand Down
0