How to achieve a web table optimized for displaying about 100 thousand data

Asked

Viewed 20 times

0

I have a service to do and I need a table optimized to work with large amount of data, about 100 thousand Rows at least... In which the person is typing and filtering the data

We have some but it doesn’t work with this amount of data.

I accept ideas, directions...

php jquery database web-application

  • Face is not for nothing, but I find it kind of hard to find one that does with this amount of data. Filtering 100,000 lines, not to mention overloading the data traffic, and if the Internet of anyone using it is bad??

1 answer

1

bootstrap dataTables.

Do you use any MVC framework? If so, it is even better to configure this plugin. If not, recommend Codeigniter to do this.

You configure the table to fetch the data via Ajax. Enter Length as 10, 25, 50, 100 etc... the amount you want. Then, when you load the page, it fetches the information in the file being entered in the url. But, beware, in case you don’t configure correctly, you might crash the page because of the amount of information.

Browser other questions tagged php jquery database web-application

You are not signed in. Login or sign up in order to post.