SQLite Forum

Thanks for SQLite version 3.34.0
Login

Thanks for SQLite version 3.34.0

(1) By jose isaias cabrera (jicman) on 2020-12-14 21:29:21 [link] [source]

I wanted to say thanks to the SQLite team for releasing v3.34.0. This version has speed up the opening of my application from 11+ seconds to less than 5 seconds. This is on a shared drive also. So, I appreciate your work.

josé

(2) By jose isaias cabrera (jicman) on 2020-12-15 18:59:26 in reply to 1 [source]

Also, loading records is also sooo much faster. I don't have a number because I was not paying attention to the importing piece, but I just noticed that is about 4 times faster. Thanks, and thanks.

josé

(3) By Richard Hipp (drh) on 2020-12-15 19:13:57 in reply to 2 [link] [source]

I don't understand why 3.34.0 is so much faster for you. There were improvements, of course, but by our measurements, 3.34.0 is only a small percentage faster than 3.33.0. Nevertheless, I'm glad it is working out well for you.

If you have a small test case that demonstrates the dramatic performance improvement in 3.34.0 that would be terrific. We could then use that test case to prevent a regression in the future. :-)

(4) By jose isaias cabrera (jicman) on 2020-12-15 19:37:21 in reply to 3 [link] [source]

I am also just as surprised. Let me research this a bit, and come back to you. Thanks.

(5) By jose isaias cabrera (jicman) on 2020-12-17 15:03:39 in reply to 3 [link] [source]

I don't understand why 3.34.0 is so much faster for you. There were improvements, of course, but by our measurements, 3.34.0 is only a small percentage faster than 3.33.0. Nevertheless, I'm glad it is working out well for you.

So, you're right. The same weekend that I upgraded my DLL from 3.33.0 to 3.34.0, there was an upgrade on the server where the Shared SQLite DB exists, and somehow, this has made the difference in speed. I tried 10 times each version (3.33.0 and 3.34.0) and they were all pretty close. So, although I am very happy with the new version, the speed noticed was caused by a change in the server. :-)