The Cursor you provide to the SimpleCursorAdapter is a resultset from the database query. If the database query is fast, then the problem is located in the CursorAdapter. I have experienced that CursorAdapters have poor performance (both using SimpleCursorAdapter and custom adapters extending CursorAdapter or ResourceAdapter).
I ended up pulling the data from the Cursor, put in in an array, and extend the ArrayAdapter, which gave me much better performance.
Thats what I prefer, too – WarrenFaith Jun 8 at 16:35 thanks for the response, @Frenkenstain. I've just tried that and noticed that the problem isn't in the setAdapter, but at the first moveToNext() in the Cursor (take more than a minute). Any ideas?
– Rodrigo Cavalcanti Jun 8 at 18:18 I created some indexes in the columns where the join's occurs. The size of the base increases, but the performance got a lot better. – Rodrigo Cavalcanti Jun 9 at 21:42.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.