I have a lot of tables in my application and after I update some rows, I reindex the tables.

db.execSQL("drop index if exists iDistListFields_PK");
db.execSQL("drop index if exists iUsersInDistList_PK");
db.execSQL("drop index if exists iContactsInDistList_PK");
db.execSQL("create index if not exists iDistListFields_PK on DistListFields(DistListID, DicFieldID)");
db.execSQL("create index if not exists iUsersInDistList_PK on UsersInDistList(DistListID, UserID)");
db.execSQL("create index if not exists iContactsInDistList_PK on ContactsInDistList(DistListID, ContactID)");

This is done a total of 15 times (drop…create). Normally this process takes about 1s to complete but I’m seeing it sometimes take anywhere from 20s to 60s to complete. The odd thing is, during that time, logcat logs NOTHING!! I was hoping to see something there to help be debug, but no!

Has anyone seen something like this before? Is there any way I can make sure logcat doesn’t stop? Any tips/suggestions?