chrislowthian
New Member
Hello I would like to know what method is faster on Android.I have a loop that process thousands of rows and I think the performance is being affected with the \[code\]SQLiteDatabase.insert()\[/code\] method. In the insert method I put a parameter with \[code\]contentvalues\[/code\] and I think in the background the method must to have a process to check every \[code\]contentvalue\[/code\] and build the query.Instead in the \[code\]execSQL\[/code\] method I put the whole query as a parameter and I think the method don't have to do that much to execute it.I don't know if i am right, I think the \[code\]execSQL\[/code\] is better than insert for a considerable quantity of data but I am not sure...