What are the columns?
On 3/30/12 12:32 PM, "Isabelle Loyer Perso" <isa_lo...@yahoo.fr> wrote: See below how xml look like: <MyDB> <p id="3557" np="DURAND Roland" pr="JF" d1=" / " dn="06/12/00" tel="06 26 14 14 34" st="1ère consult. - 02/05/11"/><p id="861" np="DUPONF Paco" pr="JF" d1=" / " dn="01/07/88" tel="01 23 33 33 45" st="Archivé - 15/06/04"/> <p id="3549" np="ATAL Sophie" pr="JF" d1=" / " dn="27/02/78" tel="06 65 40 00 28 melle" st="1ère consult. - 26/01/11"/> <p id="3453" np="ATAL Caroline" pr="JF" d1="385 / " dn="27/09/95" tel="01 49 81 23 43" st="Traitement - 26/05/11"/> </MyDB> Sort may be apply on click to datagrid header. Thanks Le 30/03/12 18:17, Alex Harui a écrit : A custom collection can help. What does a record look like, and how many columns are displayed? Is a sort applied right away or is it optional? On 3/29/12 11:14 PM, "Isabelle Loyer Perso" <isa_lo...@yahoo.fr> wrote: All record are on datagrid. All recordset must be sorting. I use sdk 4.6. Thanks for helping. Le 30/03/12 06:49, James Ong a écrit : So the whole 60k records or partial records must be visible on the page? You have not mention which flex sdk version you are using. On Mar 29, 2012 11:20 PM, "isa_loyer" <isa_lo...@yahoo.fr> wrote: Hi, I do a query to mysql database with httpservice. The result contains arround 60000 records. Time to create xml file is arround 40s, to slow for my customer. I try to accelerate the process with different methods, on server side, to generate file DOMDocument XmlWriter SimpleXMLElement As customer must be able to sort datagrid, I can not use pagging. So do you have an idea to load datagrid more speedly. Thanks -- Alex Harui Flex SDK Team Adobe Systems, Inc. http://blogs.adobe.com/aharui -- Alex Harui Flex SDK Team Adobe Systems, Inc. http://blogs.adobe.com/aharui