Can you then split your database in two? One would have the x/y/z values with a long value serving as the key into the other database, which would only have the blobs (and the key).
Another idea is to partition the data, keeping one database for x less than some predefined value (0?) and the other for x greater than or equal to that value. -- Kostya 2011/1/14 Menion <[email protected]> > 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 > -- 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
