We have an application requires sorting on a table view (sorting on 4 different columns). I know that there is not a build-in sorting on the table view itself.

So, I use the SQLite db to create a database, insert the data into the database and dynamically generate the query to do the sorting. And then bind to the titanium table view. But the result is slow. For example, it is using 8 seconds on a 3G network to load 35 records onto the table.

I have also tried using the quick sort in the javascript code, but the results is even slower.

Does anyone encounter the same issue and has done something like that? Does anyone has implemented something does sorting really fast?

Thanks in advance.