1. #1
    Sencha Premium Member
    Join Date
    Nov 2013
    Posts
    4
    Vote Rating
    0
    meyyappan is on a distinguished road

      0  

    Exclamation PagingToolbar Problem in Loading Huge datas

    PagingToolbar Problem in Loading Huge datas


    I am developing an application in ExtJS.I am using grid to display records.The Grid is loading 1200k
    row of datas from a table in database.So that i used PagingToolbar.I set the "limit" to "200".when
    clicking "Next" button it loads the next "200" records.But when clicking "Last page" button my application is crashed and takes full system memory.While looking at "Ext.PagingToolbar" source "moveLast" function gets the totalcount from the database.This seems to be the problem.how can i change this code?Could you please help me to fix this issue?

  2. #2
    Sencha - Senior Forum Manager mitchellsimoens's Avatar
    Join Date
    Mar 2007
    Location
    Gainesville, FL
    Posts
    36,789
    Vote Rating
    833
    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


    Loading 1,200k or even 1,200 records is not recommended, you need to only load 1 page at a time
    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 Premium Member
    Join Date
    Nov 2013
    Posts
    4
    Vote Rating
    0
    meyyappan is on a distinguished road

      0  

    Default


    Thanks for your reply michellsimoens.In our application we are using pagingToolBar.It seems that it loads all the records from db when we click on the navigate to last page button, when the number of records has been increased and If we try to navigate to the last page the application crashes because of the component loads all the records into the memory. We need your help to know is there any possility to restrict the component to load only the last page records instead of loading all the records in memory. It will be grateful if we get any solution or workaround to resolve this behavior.Thanks in advance.

  4. #4
    Sencha User bkraut's Avatar
    Join Date
    Nov 2007
    Location
    Maribor, Slovenia
    Posts
    402
    Vote Rating
    1
    bkraut is on a distinguished road

      0  

    Default


    As far as I understand you load all the records from the database and you set totalcount. Then you expect ExtJs will page your records. This is wrong.

    If you load 25 record per page load just 25 records on the server side and then set totalcount to all the record in the table. This way your server side will manage paging.

    I have several hundreds grids working perfectly with filters and sorting incuded.

Thread Participants: 2

Tags for this Thread

Turkiyenin en sevilen filmlerinin yer aldigi xnxx internet sitemiz olan ve porn sex tarzi bir site olan mobil porno izle sitemiz gercekten dillere destan bir durumda herkesin sevdigi bir site olarak tarihe gececege benziyor. Sitenin en belirgin ozelliklerinden birisi de Turkiyede gercekten kaliteli ve muntazam, duzenli porno izle siteleri olmamasidir. Bu yuzden iste. Ayrica en net goruntu kalitesine sahip adresinde yayinlanmaktadir. Mesela diğer sitelerimizden bahsedecek olursak, en iyi hd porno video arşivine sahip bir siteyiz. "The Best anal porn videos and slut anus, big asses movies set..." hd porno faketaxi