PDA

View Full Version : Client-Side Data Cache Editor - 5mb limit


ABC123

Scott B
03-07-2017, 07:24 PM
Hello All -

I'd like to take advantage of the client-side data cache editor in my UX component, however the data source is VERY large (>40K records, which translates to about 15MB). Using local storage is not an option due to the 5MB limit (approx.) and storing in the file system is not an option since the component is not being run in a phonegap shell (aka its not a native application).

Any advice or suggestions?

As always, thank you!
Scott

Davidk
03-07-2017, 11:23 PM
Why do you need to load and edit 40,000 records?

user10
03-08-2017, 08:04 AM
You need to use phonegap and SQLite

https://www.alphasoftware.com/blog/sqlite-html5-phonegap/

https://www.alphasoftware.com/documentation/pages/Guides/PhoneGap/Data%20Integration/SQLite.xml

Scott B
03-13-2017, 06:38 PM
Thanks John and David and apologies for the delay on my end. David, to answer your question, this is a reference table from which users need to make a selection or selections. Unfortunately, it seems its most efficient to have all of these records available.

John, as I state above, the application is not native and does not use phone gap.

Davidk
03-13-2017, 08:07 PM
What are you using, or want to use, in your UX to display the 40,000 rows? If you want to use a List control, then you can Paginate your data using the Data Pagination features in the List Source tab.