Hi Dg,
Have you put in some JavaScript Timers to see if it is the SQLite queries or the time it is taking to render the DOM change? From my experience the time it takes to execute the SQLite queries is quite fast, but DOM manipulation can be a bit slower to render especially if there are lots of changes in the DOM.
One thing you can try is to incrementally update the DOM.. For example, you can create a loop that when you are done processing the first X number of rows you exit the function by using a setTimeout() to then call a function to show the remaining rows. Kind of like a recursive function that exits calls itself by using setTimeout() to ensure the current thread is exited.
Does that make sense?
Essentially the goal is to make smaller incremental DOM updates and then use setTimeout() to exit the current JavaScript thread so that those DOM updates are displayed.
It would look something like:
var _myArray;
var _index;
function displayDetails() {
for (var i = _index; i < _index + 10; i++) {
if (i == _myArray.length - 1) return;
// .... Perform DOM manipulation
}
_index = _index + 10;
setTimeout("displayDetails()", 300);
}
Also check the speed class rating for your SD Card. It will have a direct impact on SQLite read/write speeds.
http://en.wikipedia.org/wiki/Secure_Digital#Speed_
