Bug #41532 | Slower performance since 5.1.7 with rewriteBatchedStatements option | ||
---|---|---|---|
Submitted: | 17 Dec 2008 9:06 | Modified: | 2 Apr 2009 16:13 |
Reporter: | Philippe Martin | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Connector / J | Severity: | S5 (Performance) |
Version: | 5.1.7 | OS: | Any |
Assigned to: | Mark Matthews | CPU Architecture: | Any |
Tags: | REWRITEBATCHEDSTATEMENTS |
If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.
To split a large file:
- On *nix platforms use the split command e.g.
split -b 50MB <my_large_archive> <my_split_archive_prefix>
- On windows use WinZip or a similar utility to split the large file
[18 Dec 2008 12:16]
Philippe Martin
[18 Dec 2008 12:17]
Philippe Martin
Fix minor bug for bath query with "ON DUPLICATE KEY"
Attachment: StringUtils.java (application/octet-stream, text), 55.64 KiB.
[18 Dec 2008 23:00]
Philippe Martin
Last fix diff + ServerPreparedStatement.java to compile the package
Attachment: FixDiff.txt (text/plain), 5.21 KiB.
[19 Dec 2008 10:32]
Philippe Martin
New fix: the bug is in fact in StringUtils.java
Attachment: FixDiff.txt (text/plain), 5.17 KiB.
[20 Dec 2008 18:22]
Philippe Martin
Zip of fix with tests : java files + class files + diff files
Attachment: bug-data-41532.zip (application/x-zip, text), 159.58 KiB.
[23 Dec 2008 11:05]
Philippe Martin
StringUtils diff updated, last file have not the correct diff file (java file ok)
Attachment: bug-data-41532.zip (application/x-zip, text), 159.57 KiB.