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] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
