Nice Thread and it certainly cleared my ignorance related to setting up the database.
On Oct 1, 5:57 am, Ludwig <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
