vecino Well-Known Member Licensed User Longtime User Oct 1, 2024 #1 Hello, a question about B4XTable, does it load all the records in memory or does it load them as you go from page to page? Thank you very much.
Hello, a question about B4XTable, does it load all the records in memory or does it load them as you go from page to page? Thank you very much.
Alexander Stolte Expert Licensed User Longtime User Oct 1, 2024 #2 B4XTable is using a sqlite database under the hood. This means that only the data that is required is loaded. Upvote 0
B4XTable is using a sqlite database under the hood. This means that only the data that is required is loaded.
Erel B4X founder Staff member Licensed User Longtime User Oct 1, 2024 #3 The accurate answer is yes, it holds all data in memory. It uses an in memory SQLite db. Upvote 0
vecino Well-Known Member Licensed User Longtime User Oct 1, 2024 #4 Hello, so if there are several million records in a table, does it load them all into memory? Upvote 0
jahswant Well-Known Member Licensed User Longtime User Oct 1, 2024 #5 vecino said: Hello, so if there are several million records in a table, does it load them all into memory? Click to expand... Yes Upvote 0
vecino said: Hello, so if there are several million records in a table, does it load them all into memory? Click to expand... Yes
vecino Well-Known Member Licensed User Longtime User Oct 1, 2024 #6 Thanks for the answers, friends. Upvote 0
Erel B4X founder Staff member Licensed User Longtime User Oct 1, 2024 #7 You shouldn't add millions of items to B4XTable. Even if there weren't memory limitations. No user will ever want to have a table with 100K pages. This is impractical and every search will need to filter items out of millions of items. Upvote 0
You shouldn't add millions of items to B4XTable. Even if there weren't memory limitations. No user will ever want to have a table with 100K pages. This is impractical and every search will need to filter items out of millions of items.