12 Oct 2012 8:14 PM #1
Unanswered: Ext.List and MySQL
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.
- Is this possible?
- Is there an example that I can follow to see how this is done?
14 Oct 2012 10:08 AM #2
- Join Date
- Mar 2007
- Gainesville, FL
- Vote Rating
Is the list data 6.6MB or the details of the record you tap on 6.6MB?
Sencha Inc, Senior Software Engineer
Check out my GitHub, lots of nice things for Ext JS 4 and Sencha Touch 2
Think my support is good? Get more personalized support via a support subscription. https://www.sencha.com/store/
Need more help with your app? Hire Sencha Services email@example.com
Want to learn Sencha Touch 2? Check out Sencha Touch in Action that is in print!
When posting code, please use BBCode's CODE tags.
14 Oct 2012 7:34 PM #3
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.
15 Oct 2012 6:31 AM #4
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.