LucaMs Expert Licensed User Longtime User Sep 15, 2026 #1 I drove myself crazy trying to figure out why two versions of my project were executing IDENTICAL SQLite queries (the entire Sub was identical) with vastly different execution times. After a couple of hours—and even trying to get help from Copilot—I discovered that ONLY unchecking the B4XTable library made the slow project run just as fast as the other one. Naturally, I removed everything related to B4XTable and now I only display the data in the Logs window; but believe me, what was slowing down the processing was simply the "presence" of the B4XTable library!
I drove myself crazy trying to figure out why two versions of my project were executing IDENTICAL SQLite queries (the entire Sub was identical) with vastly different execution times. After a couple of hours—and even trying to get help from Copilot—I discovered that ONLY unchecking the B4XTable library made the slow project run just as fast as the other one. Naturally, I removed everything related to B4XTable and now I only display the data in the Logs window; but believe me, what was slowing down the processing was simply the "presence" of the B4XTable library!
LucaMs Expert Licensed User Longtime User Sep 15, 2026 #2 Manifest of B4XTable: Version=1.24 B4J.DependsOn=B4XFormatter.b4xlib, jSQL, sqlite-jdbc-3.7.2, XUI Views B4A.DependsOn=B4XFormatter.b4xlib, SQL, XUI Views B4i.DependsOn=B4XFormatter.b4xlib, iSQL, XUI Views My project: #AdditionalJar: sqlite-jdbc-3.47.0.0.jar This is probably the problem. Upvote 0
Manifest of B4XTable: Version=1.24 B4J.DependsOn=B4XFormatter.b4xlib, jSQL, sqlite-jdbc-3.7.2, XUI Views B4A.DependsOn=B4XFormatter.b4xlib, SQL, XUI Views B4i.DependsOn=B4XFormatter.b4xlib, iSQL, XUI Views My project: #AdditionalJar: sqlite-jdbc-3.47.0.0.jar This is probably the problem.
aeric Expert Licensed User Longtime User Sep 15, 2026 #3 Why not use v1.25? B4X: Version=1.25 B4J.DependsOn=B4XFormatter.b4xlib, jSQL, sqlite-jdbc, XUI Views B4A.DependsOn=B4XFormatter.b4xlib, SQL, XUI Views B4i.DependsOn=B4XFormatter.b4xlib, iSQL, XUI Views Upvote 0
Why not use v1.25? B4X: Version=1.25 B4J.DependsOn=B4XFormatter.b4xlib, jSQL, sqlite-jdbc, XUI Views B4A.DependsOn=B4XFormatter.b4xlib, SQL, XUI Views B4i.DependsOn=B4XFormatter.b4xlib, iSQL, XUI Views
LucaMs Expert Licensed User Longtime User Sep 15, 2026 #4 aeric said: Why not use v1.25? B4X: Version=1.25 B4J.DependsOn=B4XFormatter.b4xlib, jSQL, sqlite-jdbc, XUI Views B4A.DependsOn=B4XFormatter.b4xlib, SQL, XUI Views B4i.DependsOn=B4XFormatter.b4xlib, iSQL, XUI Views Click to expand... Because I saw... Anyway, I modified the Manifest file (sqlite-jdbc-3.47.0.0) and now, 2 o 3 HOURS after , my project is "fast" Upvote 0
aeric said: Why not use v1.25? B4X: Version=1.25 B4J.DependsOn=B4XFormatter.b4xlib, jSQL, sqlite-jdbc, XUI Views B4A.DependsOn=B4XFormatter.b4xlib, SQL, XUI Views B4i.DependsOn=B4XFormatter.b4xlib, iSQL, XUI Views Click to expand... Because I saw... Anyway, I modified the Manifest file (sqlite-jdbc-3.47.0.0) and now, 2 o 3 HOURS after , my project is "fast"
aeric Expert Licensed User Longtime User Sep 15, 2026 #5 If I am not mistaken, B4XTable v1.25 is shipped with B4J v10.7 edit: B4J v10.7 BETA with optional parameters, jServer 5 and more I'm happy to release a new BETA version of B4J. The parser has undergone a major refactoring, resulting in performance improvements and providing the potential for new language features. The first one is optional parameters. Improvements: Optional parameters... www.b4x.com Upvote 0
If I am not mistaken, B4XTable v1.25 is shipped with B4J v10.7 edit: B4J v10.7 BETA with optional parameters, jServer 5 and more I'm happy to release a new BETA version of B4J. The parser has undergone a major refactoring, resulting in performance improvements and providing the potential for new language features. The first one is optional parameters. Improvements: Optional parameters... www.b4x.com
LucaMs Expert Licensed User Longtime User Sep 15, 2026 #6 aeric said: If I am not mistaken, B4XTable v1.25 is shipped with B4J v10.7 Click to expand... ...which I uninstalled because it causes issues with CustomListView and Java 8. Only Java 8 generates standalone executable .jar files (UI). Upvote 0
aeric said: If I am not mistaken, B4XTable v1.25 is shipped with B4J v10.7 Click to expand... ...which I uninstalled because it causes issues with CustomListView and Java 8. Only Java 8 generates standalone executable .jar files (UI).
aeric Expert Licensed User Longtime User Sep 15, 2026 #7 LucaMs said: ...which I uninstalled because it causes issues with CustomListView and Java 8. Only Java 8 generates standalone executable .jar files (UI). Click to expand... Oh, but I prefer Jdk11+ with InnoSetup. So far I don't get any error using new versions of B4J. Upvote 0
LucaMs said: ...which I uninstalled because it causes issues with CustomListView and Java 8. Only Java 8 generates standalone executable .jar files (UI). Click to expand... Oh, but I prefer Jdk11+ with InnoSetup. So far I don't get any error using new versions of B4J.
LucaMs Expert Licensed User Longtime User Sep 15, 2026 #8 aeric said: Oh, but I prefer Jdk11+ with InnoSetup. So far I don't get any error using new versions of B4J. Click to expand... Yes, but InnoSetup is fine for the final version. Upvote 0
aeric said: Oh, but I prefer Jdk11+ with InnoSetup. So far I don't get any error using new versions of B4J. Click to expand... Yes, but InnoSetup is fine for the final version.
AnandGupta Expert Licensed User Longtime User Sep 15, 2026 #9 So the latest B4J do not have this B4XTable slow sql bug, right ? Just to confirm from this discussion for better good for all readers. Upvote 0
So the latest B4J do not have this B4XTable slow sql bug, right ? Just to confirm from this discussion for better good for all readers.
aeric Expert Licensed User Longtime User Sep 15, 2026 #10 AnandGupta said: So the latest B4J do not have this B4XTable slow sql bug, right ? Just to confirm from this discussion for better good for all readers. Click to expand... As far as I know, I never experienced slow for both v1.24 and v1.25. Upvote 0
AnandGupta said: So the latest B4J do not have this B4XTable slow sql bug, right ? Just to confirm from this discussion for better good for all readers. Click to expand... As far as I know, I never experienced slow for both v1.24 and v1.25.
LucaMs Expert Licensed User Longtime User Sep 15, 2026 #11 AnandGupta said: So the latest B4J do not have this B4XTable slow sql bug, right ? Just to confirm from this discussion for better good for all readers. Click to expand... SQLite queries slow down significantly if the project uses a different SQLite driver than the one used by the B4XTable library. Based on what @aeric wrote: aeric said: B4J.DependsOn=B4XFormatter.b4xlib, jSQL, sqlite-jdbc, XUI Views Click to expand... I think that in B4J version 10.7, the driver version is no longer specified in the Manifest and this might have resolved the issue. Upvote 0
AnandGupta said: So the latest B4J do not have this B4XTable slow sql bug, right ? Just to confirm from this discussion for better good for all readers. Click to expand... SQLite queries slow down significantly if the project uses a different SQLite driver than the one used by the B4XTable library. Based on what @aeric wrote: aeric said: B4J.DependsOn=B4XFormatter.b4xlib, jSQL, sqlite-jdbc, XUI Views Click to expand... I think that in B4J version 10.7, the driver version is no longer specified in the Manifest and this might have resolved the issue.
aeric Expert Licensed User Longtime User Sep 15, 2026 #12 LucaMs said: in B4J version 10.7, the driver version is no longer specified in the Manifest Click to expand... In the past, we need to rename newer version to 3.7.2 or edit the version number in manifest inside the B4XTable.b4xlib to point to a specific version. Actually it is not much different. It still point to sqlite-jdbc but it seems it makes more sense than having a newer version 3.47.0 with the name sqlite-jdbc-3.7.2. I never tested a project using two different versions of SQLite, one used by B4XTable, the other for general SQL queries. I think it will be conflicted. Upvote 0
LucaMs said: in B4J version 10.7, the driver version is no longer specified in the Manifest Click to expand... In the past, we need to rename newer version to 3.7.2 or edit the version number in manifest inside the B4XTable.b4xlib to point to a specific version. Actually it is not much different. It still point to sqlite-jdbc but it seems it makes more sense than having a newer version 3.47.0 with the name sqlite-jdbc-3.7.2. I never tested a project using two different versions of SQLite, one used by B4XTable, the other for general SQL queries. I think it will be conflicted.
