Querying and displaying data from a SQLite database and other thoughts

Hi Eric/Carlos/Tim,
Last week playing with Corona and asking questions to understand how to do things has been quite fun filled. As one of the videos states, Physics in 5 lines of code, well, one can make a fully functional game in about 100 lines of code. It is so easy...

Database access was and could never be more simpler, I just love that in two lines of code, I have the database queried and results returned.

Now comes the part where I need to display them. This is where the issue lies. Using the TableView component created in Lua is Sllloooooooooooowwwww.

Where on the Native UITableView, I can scroll 10,000 items without even flinching, here it takes about 30 seconds to first display all of the 3000 records and then if I try to scroll them ;)

Why can we not have access to the native UI components instead? A kind of a LUA wrapper to the Native components, that way we the developers can get speed and work with it efficiently and Corona SDK becomes more acceptable not only for games but for other types of development. I understand that you do things the way you do to maintain compatibility, but you can also give the developers a conditional block for certain platforms, so I can have a #IF TARGETED_OS = _ANDROID_ only for native UI components. Coz if I as a developer am developing certain elements for a targeted platform, I may not intend to develop for another and if I do, I am happy to change the needful.

I did ask this question and did notice that a build with the GE adds a bload for OpenFeint, there should be an option that allows the developer to add certain modules. A simple build app takes up 3.5 MB without doing anything. It is a bit too much for small utilities, where as in a game with MB's of sound and graphics, that is negligible.

On the topic of sound, can you add native support for synth sounds?? It is easy, it is all about a frequency and a duration. So if you can add three channels or four channels of synth sounds, I am sure that you will make a revolution in this market. The MP3 and wav or caf sounds take up too much space. These will take lesser space and *maybe* provide a better experience too.

just a few random thought for you,

cheers,

Jayant C Varma

views:1761 update:2011/9/19 9:18:26
corona forums © 2003-2011