1. #1
    Sencha User
    Join Date
    Sep 2012
    Posts
    2
    Vote Rating
    0
    cortexuvula is on a distinguished road

      0  

    Default Unanswered: Ext.List and MySQL

    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.

    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.

  2. #2
    Sencha - Senior Forum Manager mitchellsimoens's Avatar
    Join Date
    Mar 2007
    Location
    Gainesville, FL
    Posts
    37,330
    Answers
    3541
    Vote Rating
    847
    mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute

      0  

    Default


    Is the list data 6.6MB or the details of the record you tap on 6.6MB?
    Mitchell Simoens @SenchaMitch
    Sencha Inc, Senior Forum Manager
    ________________
    Check out my GitHub, lots of nice things for Ext JS 4 and Sencha Touch 2
    https://github.com/mitchellsimoens

    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 services@sencha.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.

  3. #3
    Sencha User
    Join Date
    Sep 2012
    Posts
    2
    Vote Rating
    0
    cortexuvula is on a distinguished road

      0  

    Default


    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.

  4. #4
    Sencha User
    Join Date
    Jan 2012
    Location
    London, UK
    Posts
    502
    Answers
    25
    Vote Rating
    55
    shepsii is a jewel in the rough shepsii is a jewel in the rough shepsii is a jewel in the rough

      0  

    Default


    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.

Thread Participants: 2

Tags for this Thread