0

I want to load millions of data from Django with search bars on each column to search all the database quickly on server-side. However, there is no datatable example for django with server-side and column search bar.

I tried django-datatable-view and I can load the dataset with server-side. But I could not implement the column searchbar on the whole dataset.

Elegant Lin
  • 25
  • 2
  • 10

2 Answers2

0

Take a look at Datatable's Server-side processing option, DataTables will perform an Ajax request for each datatable manipulation like paging, searching ...

Server-side processing

however you will have to implement datatable in a native way

Szakaria
  • 379
  • 3
  • 8
  • Thanks for your quick comments. Yes, I have finished the paging, however, I couldn't add search bar on every column and the search is only for this page (What I want is the whole database). Could your solution help with this? I haven't tried, sorry. Thanks anyway ! – Elegant Lin Jun 26 '19 at 12:48
  • as i said before Server-side processing perfom an ajax call to server side instead of just searching in the DOM, so yes with this option you can search in your database – Szakaria Jun 26 '19 at 13:30
  • Thanks a lot. I have finished it. :) – Elegant Lin Jul 15 '19 at 11:53
0

It seem you queries are most search extensive in huge Data. I would recommended using Elastic Search

Ashutosh gupta
  • 447
  • 4
  • 16