there are multiple reasons to not use a dynamic sql string with execSQL, among the most obvious are permissions (granting universal select permission on tables is generally considered a poor...
I have seen performance degradation like this before in data intensive processes. 2 tecniques I would recommend: 1) either at the beginning or end of the process,...