There is a very good chance that something somewhere isn't dealing correctly with a file > 2GB. Keep a single file less than 2 GB to be safe. (FAT 32 is limited to 4 GB, but there is a good chance at some point in the path above it there is a signed int somewhere that is causing something to break.)
On Fri, Jan 14, 2011 at 7:58 AM, Menion <[email protected]> wrote: > only one info > > database 1.8GB works fine > > database 2.5GB do not work! > > On Jan 14, 4:44 pm, Menion <[email protected]> wrote: > > nono, data aren't corrupted > > > > when I use SQLite Database Browser 2.0b1 (desktop software) all SQL > > string done fine, just takes a too much time too. This database is > > user database with map tiles. Same can be created in application but > > this tests are done only on READ_ONLY opened database! > > > > In my case it's problem thanks to size of database, when I create same > > but only 1GB big, all works fine. I'm mainly asking if you don't know > > any other SQL command that check and return Z values for me. > > > > I also tried > > > > int minZoom = 8; > > int maxZoom = 29; > > ArrayList<Integer> testZooms = new > ArrayList<Integer>(); > > for (int i = maxZoom; i >= minZoom; i--) { > > int testZoom = 25 - i; > > Cursor cursor = > sql.query(SqLiteCache.SQL_TABLE_TILES, null, > > SqlTableTilesColumns.Z + > "==" + testZoom, > > null, null, null, null, > "1"); > > if (cursor.getCount() == 1) { > > // zoom exist > > testZooms.add(i); > > } > > cursor.close(); > > } > > > > that should test every available zoom but it's the same. > > > > hope you understand me :) > > > > thanks guys > > On Jan 14, 3:47 pm, Marcin Orlowski <[email protected]> wrote: > > > > > On 14 January 2011 15:24, Menion <[email protected]> wrote: > > > > > > I'm testing on one big database, more then 2GB (stored on SD card of > > > > have you please any tip how to solve this?? > > > > > Maybe consider moving your DB to external machine and exposing via any > API. > > > Depending on the purspose, how often data is updated/queried etc it > might > > > have sense > > -- > 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]<android-developers%[email protected]> > For more options, visit this group at > http://groups.google.com/group/android-developers?hl=en > -- Dianne Hackborn Android framework engineer [email protected] Note: please don't send private questions to me, as I don't have time to provide private support, and so won't reply to such e-mails. All such questions should be posted on public forums, where I and others can see and answer them. -- 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
