On Jan 14, 2:24 pm, Menion <menion.as...@gmail.com> wrote: > CREATE TABLE tiles (x INTEGER,y INTEGER,z INTEGER,s INTEGER,image > BYTE, PRIMARY KEY (x, y, z, s));
> SELECT DISTINCT z FROM tiles You need to create an index on z, then it will be much faster. > disk I/O error That's not good, but it will be hard to debug. If you just create an index it will be so much faster that it probably won't hit the bug any more. Or, if you do get the error, you could just retry. -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en