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
