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?Mitchell Simoens @LikelyMitch
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 firstname.lastname@example.org
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.