Posted by Ari Gold on April 25, 2012 at 8:11pm
I'm using d.o/project/slickgrid and used devel generate to add 1000 nodes, and some exposed filters. The filters work quite fast when searching for a specific string, but when I "reset" to load the entire slickgrid again, it takes about 30 seconds to load. Any suggestions on how to optimize so it loads quicker?
Comments
What is the code path?
What does cachegrind say takes the longest amount of time?
Sound like you may have been using slickgrid incorrectly
Best way to use slickgrid is to upload only once, then as you select a cell and make changes, use ajax to post those individual changes back to the common DB, and others users do the same, and when the ajax interface detects a change, it posts the changed cell back to your browser (much faster that a complete reload), which refreshes the cells that are visible, or as you scroll displays the "current" cell contents. This is the basis for what is known as "single page apps", with the caviat being, if you should close the page, and come back you will need a complete refresh.
This is why Drupal forms are slow when lots of data, you move away from a page and come back and your browser needs to reload that entire page, even clicking submit on a form triggers a complete page refresh and all the server side, and client side processing, I venture to say that someday Drupal will provide forms that work entirely on your browser machine, except for keeping the server in sync, but evolution is sometimes slow (almost as slow as a page reload).