I'm just starting to use datatables (java script) for tablet data, due to js, i like searching I'm able to use functions, how many rows per page, sorting and panning the page before using JS, I was just showing data in the table (Ajax used to score on the page), but Unable to use the above versions (in this Performance met was good). Now I am using jquery.dataTables.js and jquery.js files for table structure. But the problem is that it has severely affected the site's performance, initially all the scripts were under one page, then Firefox was giving warning message as a "non-responsive script", then I created a separate file for the table I made it closed, but the bad performance what I do, I get the data from the API, store it in the database and then show it to me. Although Jake is taking a lot of time, sometimes it does not display the table on thousands of figures.
I really need to use JS for the table but can not afford this poor performance. Has anyone got this problem before?
Waiting for valuable advice
You do not store tens of thousands of rows of data efficiently in JavaScript Can and manipulate. Due to the speed of gubbins (indexes, caches), search (queries) of all types of database engines like MySQL, JavaScript has none of these, and you can customize your method of storage and search algorithms as much as you want. But you will never complete an efficient solution.
Pagination should be on the server. The server sends you 30 rows data, when you want more, you request more from the server; Generally, an AJAX request to replace existing content with a second group of results, as a new page load or to add / add new content to the existing.
When you want to search for data, using JavaScript you are fine to search within the content on the page (~ 10 rows), but to find the entire dataset, the query is returned to the server Send and let your database engine work.
Comments
Post a Comment