[jQuery] tablesorter Speed issues
Hi folks, I've just started using tablesorter for one of my projects, and overall I love it. Does just what I need. The one issue I've come across is that it's S-L-O-W! On a small table, it's just fine. Once I get up to about 400 rows, however, it takes a long time. 6 seconds before the list appears sorted, and another 10 seconds before I actually regain control of the browser (Firefox 3.08 / Win32 in this case). Is this normal? Should it really take that long to sort 400 rows of data? I could understand if it were 4,000 rows, but 400 doesn't seem like much. In fact it would probably be quicker to just do a round-trip to the server and let the database do the sorting. I'm looking for some practical experience and / or suggestions from anyone who may be working with tablesorter on large tables. Thanks! - Bryan -- View this message in context: http://www.nabble.com/tablesorter-Speed-issues-tp22977435s27240p22977435.html Sent from the jQuery General Discussion mailing list archive at Nabble.com.
[jQuery] Re: tablesorter Speed issues
Thanks for the response -- I may need to do that. I'm curious if anyone else has input on the speed of Tablesorter, however. I've seen other solutions that can sort a large table quickly. For example http://dynamictable.com/demos/ Dynamic Table Demo handles 1,000 rows in about 1 second. There may be a bit of Apples and Oranges here. Tablesorter can sort on multiple columns, do zebra striping, etc., so it's more functional, but 16x slower seems like an unusually large difference. I just want to verify that this is normal for tablesorter, and not something I've done wrong with my implementation of it Thanks! - Bryan MorningZ wrote: I'd look at doing some server side sorting if you are looking for speed... it's a lot of work for the plugin to sort the client side data and then redraw 400 rows of data -- View this message in context: http://www.nabble.com/tablesorter-Speed-issues-tp22977435s27240p22978405.html Sent from the jQuery General Discussion mailing list archive at Nabble.com.
[jQuery] Re: tablesorter Speed issues
Okay, my bad here. Thanks to the one-on-one help of one of the great members here, I was able to find the problem. It wasn't the software, it was the hardware. There was something odd going on with the development PC I was using to run the test. Not only was my sort running very slow, so were the tests on http://tablesorter.com/docs/example-triggers.html tablesorter.com . When I switched to another machine, the sorts were damned near sub-second. Low-and-behold, I reboot the development machine and now it too sorts quickly. Stupid. Stupid. Stupid. Sorry to waste your time. - Bryan csi95 wrote: Hi folks, I've just started using tablesorter for one of my projects, and overall I love it. Does just what I need. The one issue I've come across is that it's S-L-O-W! On a small table, it's just fine. Once I get up to about 400 rows, however, it takes a long time. 6 seconds before the list appears sorted, and another 10 seconds before I actually regain control of the browser (Firefox 3.08 / Win32 in this case). Is this normal? Should it really take that long to sort 400 rows of data? I could understand if it were 4,000 rows, but 400 doesn't seem like much. In fact it would probably be quicker to just do a round-trip to the server and let the database do the sorting. I'm looking for some practical experience and / or suggestions from anyone who may be working with tablesorter on large tables. Thanks! - Bryan -- View this message in context: http://www.nabble.com/tablesorter-Speed-issues-tp22977435s27240p22979400.html Sent from the jQuery General Discussion mailing list archive at Nabble.com.
