Tuesday, March 22, 2011

Sqlite db max size

In Safari/iPhone, sqlite databases are allocated 5MB by default. When usage goes up, Safari prompts user to confirm reallocating to 10MB. The next level is 25MB. If there is more than one db for a domain, all the max size settings are the same, even after increasing allocation. I have tried about 50 databases in one domain (easy to do with js object instantiation) now increased to 25MB. If each db was allocated 25MB, that would be 1.2GB total. I think the 25MB max is for the whole domain. That's why all databases say 25MB even empty one showing 20KB used.

No comments:

Post a Comment