jQuery searchable paginated tables?

C

cyclone3d

[H]F Junkie
Joined
Aug 16, 2004
Messages
16,298
I am looking specifically for a search filter that works with paginated tablesorter tables:

http://tablesorter.com/docs/

I found one that was specifically made for tablesorter, but it doesn't work with the pager plugin:

http://code.google.com/p/tablesorter-extras/

I like the tablesorter package because it is a lot smaller and faster than other packages I have been able to find.

TinyTable is smaller, but extremely slow compared to tablesorter.

I have also come across, DataTables. And although it looks like it would do what I need, it is an extremely large package compared to tablesorter.... then again, once I get all the plugins i need for tablesorter it may end up being about the same.

Anybody have any experience with any of these packages? What about using really large tables.. say up to about 10,000 rows? (TinyTable is extremely slow with high numbers of table rows).
 
Oh indeed, once you get Tablesorter matching the functionality of DataTables, you are going to be looking at similar footprints.

For what it does, DataTables is tiny at ~60kb in minified form. I use DataTables a lot for web application interfaces that deal with LARGE sets of data. It handles 10's of thousands of rows no problem, rather using static html tables or it's built in ajax.

Likewise, I have made use of Tablesorter for simple tables on public sites. When you don't need all the features of DataTables, it's a good fit.
 
We tried http://www.frequency-decoder.com/2006/09/16/unobtrusive-table-sort-script-revisited in the past for table sorting here at work.

It caused problems for our clients because some users would get the "script is not responding, stop/continue" kind of error messages in their browsers. We got a lot of complaints about slowness because of it. I think part of it may have been that some users had slow computers, but I'm unsure.

Another issue is that it was only able to sort data that is currently loaded on the page, so sorting tables that were paginated was kind of meaningless.

I ended up removing all of the tablesorting scripts on the site. I made the table headers clickable, and let the database sort it in the order by. It ended up being faster, and able to sort across the whole data set. The users were much happier with it as it felt much more responsive to them.

I'm not sure how the performance of the script I used compares to the ones you mentioned, but that was my experience with javascript table sorting.
 
Thanks for the input. I'm going to go ahead and try out DataTables. I am hoping it is at least as fast as Tablesorter.
 
It looks like DataTables is the current winner.

It took some reworking of my page styling/formatting because I am using the demo css as a css template for the DataTable table.

The sorting isn't as fast as tablesorter, but that is probably going to be a moot point.

I like the search filter though. And although the search isn't quite as fast as I would like, I am thinking it may be because I haven't split it up into seperate column searches. It is still doing the default whole table search.
 
If it's not too late, you may want to look at jqGrid: http://www.trirand.com/blog/. It's hefty, but has pretty much everything: editable cells, searchable, pager, tree grids, and more. Also, the downloader has a nice feature where you can pick the features you want to use, giving the possibility for a much lighter package.
 
khaki said:
If it's not too late, you may want to look at jqGrid: http://www.trirand.com/blog/. It's hefty, but has pretty much everything: editable cells, searchable, pager, tree grids, and more. Also, the downloader has a nice feature where you can pick the features you want to use, giving the possibility for a much lighter package.
Click to expand...

Nice... and they just released 3.8 beta.... and it looks cooler.

Now I will have to try it out as well.... hrmmm.
 
Guys great links! I didn't even know until today about either DataTables or jqGrid...
 
jqGrid is quite a bit faster than DataTables when sorting large amounts of data.
 
You must log in or register to reply here.
Back
Top