Can you share a sample app in which you are facing these performance issues ??
I've attached one app which does a bunch of sql select/insert sync operations. You could just run the app & attach the screenshot when app launches.
PS: App may take some time before the initial screen comes up.
You can download my app at http://www.peaya.com/paper/download.html
After launching, you can log in as demo (File|Log in, click View Demo). Then click "Untagged" on the left tag tree. The app will retrieve records. The sql statement for such retrieval is:
this.stmt.text = "SELECT id FROM paper, paperCategoryRelation WHERE paperCategoryRelation.categoryID=:categoryID AND paper.id=paperCategoryRelation.paperID";
The performance is fine on some computers (my desktop Win 7, laptop Mac OS X), but it's extremely slow on my linux and XP which are vitual system installed using VMware. So maybe it's b/c of the vmware?
I also test your app on (1) my Mac OS X desktop (2) Win XP VMware on top of Mac OS X desktop. See attached. I find the performance of your app is fine on both systems. Did you use "join" select in your app?
Thanks for the info. I'll try out the app & revert back to you soon. Meanwhile, can you try running the app I shared with you on your Ubuntu box & attach the screenshot.
I tried your app on Ubuntu 9.10 (a native machine) with latest AIR 2.0 beta but it works just fine for me. The "Untagged" tab opens up in a flash without any visible delays.
A few questions though:
1) Which Ubuntu version are you on ?
2) Is it 32/64-bit ?
3) Which version of AIR are you on ? You might want to try it out with the latest public Beta build http://labs.adobe.com/downloads/air2.html
AIR 2 doesn't fix the problem.
I think the reason is the virtual machine. The join select statement doesn't work well inside VMware (linux or windows xp). Not sure if you will consider this as a bug but it would be nice to improve it.