分页，搜索和排序近100000条记录[已结束]

Question

I have 100000 records in my database with 10 column

which are int, float

My question

I want to perform paging, search & sorting operation on this data.

I think i have two option.

either using Ajax request for each call or retrieve all data at time,perform operations like search, sort

suggest any better solution.

NOTE: Im using Meteor.js and numbtel:mysql package

Answer 1

Better you can try bootstrap framework(data tables). it can easily to integrate for large number of rows

including the DataTables Bootstrap files (CSS and JS)