Ext.List and MySQL

[cortexuvula]

I am developing a app that retrieves a list of Airports from a remote MySQL database and list them in a Ext.List When the user taps the disclose button it will reveal more information about the airport.

My initial setup was just to retrieve the whole database into a store but the problem is that the database size is 6.6MB and this is a problem bandwidth and time wise. I thought that I could retrieve only the id and airport name for the list and then tapping on the disclose button will initiate a new store and retrieval for the MySQL database based on the id of the airport.

QUESTION:

1. Is this possible?
2. Is there an example that I can follow to see how this is done?

Thanks for the response in advance.

[mitchellsimoens]

Is the list data 6.6MB or the details of the record you tap on 6.6MB?

[cortexuvula]

When I create the list, I basically download all the information connected with each airport so when the list initialize the download is 6.6MB.

Thanks for the reply.

[shepsii]

I would advise using the pageSize parameter on initializing the list. This will require server side implementation to add an appropriate LIMIT clause the the MySQL query.