Fastest way to load a data store
What is the fastest way to load an Ext data store in IE 6 using ASP.NET to supply the data ?
I have a set of data 3000+ rows and 30 columns and i want to do client side paging to remove the issues with server side paging with sorting and filtering.
It all works fine but the initial datastore load takes 40+ seconds!
i am currently using an XmlReader but firefox tells me that the request for the data takes 5 seconds but the store takes 40+ seconds to populate! Is it better to create an array / JSON string server side before passing back the data?
Loading that many rows/columns is going to be a performance issue regardless of how you handle it. That being said, there are a number of Extensions for other ways to approach larger datasets - LiveGrid is one.
If you have control over the server code, you are better off converting to JSON. It will serialize back to objects in the browser faster than XML parsing. Depending on the data structure, you may also find that data size transmitted for JSON is smaller too.
Thanks for the reply
I've had a lood at LiveGrid and like it but again its server side paging raising issues with filtering and sorting. I'll try using JSON to see if the store load is any quicker.