The call to setMaximumSize(size) restricts the DB to that size, it is not a function to preallocate or reserve that space. If you get to the maximum size you will get an error that the DB is full.In the course of normal action you do not need to set the maximum size, it will just grow with the data.
However, while the theoretical limits of SQLite should be in the region of 2/4 GB, in practice you will have problems processing that size of data on a mobile device. Even on real computers people tend to use real DB systems for anything larger than, say, 100MB, and most users would not be happy if you chomped away on a million rows in a table. Ludwig 2008/10/1 Shraddha <[EMAIL PROTECTED]> > > Thanks. > Additionally, what if the size of my database grows beyond the memory > specified? Will it automatically increase to accommodate increased > space requirement ? > > > On Oct 1, 11:50 am, hackbod <[EMAIL PROTECTED]> wrote: > > There is no limit on the size of the database, except for available > > storage. > > > > On Sep 30, 11:06 pm, Shraddha <[EMAIL PROTECTED]> wrote: > > > > > I am considering two options of creating database and interested in > > > knowing the maximum size that can be given to a database. > > > 1. I see that SQLlite allows us to set the maximum size allowable for > > > the database. Can this be set to the maximum available on the > > > device ? > > > 2. What would be the maximum allowable size of database if I use > > > content provider ? > > > > > In other words, What is the max size a db can grow on thee Android > > > device, can it cover the total available memory space of the app, or > > > it has its own limit? > > > > > Thanks for ur time. > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---
