Super Sale Limited Time 50% OFF for All-Access Plans
Save 50% Now

Load time on datatables


We are a devt team and want to build a new solution so we decided to try the loading time of the data tables of the newest version. For this we decided to do some tests as follows:

We used core PHP to echo out a table containing 500,000 records with 6 attributes.

#1. When we use plain tables with no table class, we get all data loading in 1 minute, 27 seconds.

#2. When we use introduce the class that shows search, sorting, pagination, we got 40 minutes.


Text formatting options
Submit
Click any option to insert into your comment. Select text first to wrap it.
  • **text** to make things bold
  • *text* to emphasize
  • ### Heading to make headings
  • [link text](url) for links
  • ![alt text](image-url) to paste in an image
  • - item to make a list
  • 1. item to make an ordered list
  • > quote to quote somebody
  • `code` for single line of code
  • ```js ... ``` for JS code block
  • ```html ... ``` for HTML code block
  • ```scss ... ``` for SCSS code block
  • ```php ... ``` for PHP code block
  • --- for a horizontal rule
  • happy  :)
  • shocked  :|
  • sad  :(

Replies (5)


Hi,

If you are working with a large database, you may want to consider using the server-side option provided by DataTables.

With server-side processing enabled, all actions that DataTables perform (such as paging, searching, and ordering) are submitted to a server where a SQL engine (or similar) can perform these actions on large datasets.

Therefore, each table draw will result in a new Ajax request to retrieve the required data.

Thanks



How do I turn it on? I didn't find the documents in version 8 vuejs.



Hi Artem Sib,

For vue, please create another support question with the vue tag. Vue has a different datatable from the datatable in PHP.

Thanks



Super.

Worked like a charm. Thanks!



Great!
Have a nice day

Thanks


Your Support Matters!

We will highly appreciate your Metronic Review on Themeforest.
Please go to Themeforest Downloads page, select Metronic & leave your feedback.
Text formatting options
Submit
Click any option to insert into your comment. Select text first to wrap it.
  • **text** to make things bold
  • *text* to emphasize
  • ### Heading to make headings
  • [link text](url) for links
  • ![alt text](image-url) to paste in an image
  • - item to make a list
  • 1. item to make an ordered list
  • > quote to quote somebody
  • `code` for single line of code
  • ```js ... ``` for JS code block
  • ```html ... ``` for HTML code block
  • ```scss ... ``` for SCSS code block
  • ```php ... ``` for PHP code block
  • --- for a horizontal rule
  • happy  :)
  • shocked  :|
  • sad  :(
Text formatting options
Submit
Click any option to insert into your comment. Select text first to wrap it.
  • **text** to make things bold
  • *text* to emphasize
  • ### Heading to make headings
  • [link text](url) for links
  • ![alt text](image-url) to paste in an image
  • - item to make a list
  • 1. item to make an ordered list
  • > quote to quote somebody
  • `code` for single line of code
  • ```js ... ``` for JS code block
  • ```html ... ``` for HTML code block
  • ```scss ... ``` for SCSS code block
  • ```php ... ``` for PHP code block
  • --- for a horizontal rule
  • happy  :)
  • shocked  :|
  • sad  :(