Search data faster big table

dasapa

Hi,

i have an application with datatables. In a specific table there are around 500.000 records, it runs perfect. Table load in 1-2 seconds. Table has individual column filter, when i look for a record it takes around 15-20 seconds and i want to reduce this time because table will be bigger...someone knows if is there any way to look for data faster?

i have thought delete individual column filter and insert a form with a select boxes with value of the columns and a text box to insert data that we need look and send this data serversideprocessing.php but o dont know if is possible? someone have made this? it reduces time to swow data?

Thnaks