CODEWITHSUNDEEP
javascripthtmllocal-storageweb-sql
Fostah
Fostah

Reputation: 2946

HTML5 WebSQL optimization/caching options?

I currently have an HTML5 web app that utilizes localstorage/websql/app cache.

Now that the database size has grown to around 12MB, the queries that are returning 1000s of records at a time are causing long load times. The client does not want to use paging which would solve this problem, but it looks like I will have to load a small subset of the data and then load the rest. But I was curious if anyone had any other ideas/approaches that might speed up the large queries via caching or some other type of optimization.

Platform:iPad 1/2

Upvotes: 3

Views: 589

Answers (1)

Howard
Howard

Reputation: 3895

How about infinite scrolling instead of pagination? We've used it to great effect at https://gg.com/blogs/

As far as optimisation goes, could you load 100 records at a time instead? When you get the first 100, fire a call to fetch the next 100 and so on until you're done?

Upvotes: 2

Related Questions