Topic: Problem with search in datatable

DerLino free asked 3 years ago


I want to add a datatable to a tab content with search input but the search doesn't work.

I add this code: https://mdbootstrap.com/snippets/standard/derlino/2887512#html-tab-view

Do you know why I have problems with that? The normal datatable functions work well but javascript seems to make problems


Grzegorz Bujański staff answered 3 years ago


In your code you refer to an element with id = datatable, but in html you do not have such an element. There is only an element with a datatable class.


DerLino free commented 3 years ago

Ah I'm lost :D Thank you for this. But now I've the next problem.

1. The search datatable with round about 50.000 data entries is really slow if want to search something. Is there something that I could do if I have much data?

2. If I search f.e. "3875", than ther're entries with the number "903" f.e. Here the example: https://www.directupload.net/file/d/6106/6odnjnmz_png.htm


Grzegorz Bujański staff commented 3 years ago

That's actually a lot of data. In this situation, you should consider loading data asynchronously. Similarly, with search, it should then be handled asynchronously. Unfortunately, datatable does not have a built-in option that will enable this.


FREE CONSULTATION

Hire our experts to build a dedicated project. We'll analyze your business requirements, for free.

Status

Closed

Specification of the issue

  • ForumUser: Free
  • Premium support: No
  • Technology: MDB Standard
  • MDB Version: 3.2.0
  • Device: PC
  • Browser: Firefox
  • OS: Windows 10
  • Provided sample code: No
  • Provided link: Yes