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
Here's a how to add some HTML formatting to your comment:
  • <pre></pre> for JS codes block
  • <pre lang="html"></pre> for HTML code block
  • <pre lang="scss"></pre> for SCSS code block
  • <pre lang="php"></pre> for PHP code block
  • <code></code> for single line of code
  • <strong></strong> to make things bold
  • <em></em> to emphasize
  • <ul><li></li></ul>  to make list
  • <ol><li></li></ol>  to make ordered list
  • <h3></h3> to make headings
  • <a></a> for links
  • <img> to paste in an image
  • <blockquote></blockquote> to quote somebody
  • 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
Here's a how to add some HTML formatting to your comment:
  • <pre></pre> for JS codes block
  • <pre lang="html"></pre> for HTML code block
  • <pre lang="scss"></pre> for SCSS code block
  • <pre lang="php"></pre> for PHP code block
  • <code></code> for single line of code
  • <strong></strong> to make things bold
  • <em></em> to emphasize
  • <ul><li></li></ul>  to make list
  • <ol><li></li></ol>  to make ordered list
  • <h3></h3> to make headings
  • <a></a> for links
  • <img> to paste in an image
  • <blockquote></blockquote> to quote somebody
  • happy  :)
  • shocked  :|
  • sad  :(
Text formatting options
Submit
Here's a how to add some HTML formatting to your comment:
  • <pre></pre> for JS codes block
  • <pre lang="html"></pre> for HTML code block
  • <pre lang="scss"></pre> for SCSS code block
  • <pre lang="php"></pre> for PHP code block
  • <code></code> for single line of code
  • <strong></strong> to make things bold
  • <em></em> to emphasize
  • <ul><li></li></ul>  to make list
  • <ol><li></li></ol>  to make ordered list
  • <h3></h3> to make headings
  • <a></a> for links
  • <img> to paste in an image
  • <blockquote></blockquote> to quote somebody
  • happy  :)
  • shocked  :|
  • sad  :(