Saturday, 24 August 2013

Android improve SQL processing speed

Android improve SQL processing speed

I'm processing 31000 Insert SQL statements reading from a file and it
takes more than 2 minutes to complete.. need some advice in improving
performance..
Here is the code:
while((line=reader.readLine())!=null){
dbs.execSQL(line);
k=(int)(i*0.0032);
if(k%10==0){fdb.publishProgress(k);}
i++;
}

No comments:

Post a Comment