开发者

Plugin or module for filtering/sorting a large amount of data?

开发者 https://www.devze.com 2022-12-24 06:57 出处:网络
I have a rather large amount of data (100 MB or so), that I would like to present to a user. The format of the data is similar to the following...

I have a rather large amount of data (100 MB or so), that I would like to present to a user. The format of the data is similar to the following...

Date       开发者_开发百科;       Location      Log File          Link

03/21/2010   San Diego   some_log.txt   http://somelink.com

etc

My problem is that I would like to have some nice/slick way for the user to filter the information. Unfortunately, because there is so much of it, the jQuery Table Filter plugin does not work (crashes the browser). I was wondering if there is a nice solution or if I have to simply do the filtering on the server end and have a bland pull-down menu / select-box interface for the client to use.


100MB is pretty huge. You don't want to transfer all that data at once to the client side on a single request and then do the paging/filtering/sorting actions over there. It would take ages to transfer it and it would eat all the client's memory. Rather do that entirely at the server side on every request using SQL powers. SQL can do it much more efficient than Java/JavaScript. I've posted a similar answer with more technical details and code examplpes before here.


Use paging. (Maybe a little ajax).


If the browser has Google Gears installed for its DB API or supports HTML5's Web SQL Database (e.g. Opera 10.5+), you can import all the data into a client-side SQL database and perform the sorting+paging queries with SQL.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号