PHP Oracle DataTable 1.10 - Pagination/ Search not working

sagartoshniwal

I am using PHP 5.4 with DataTables 1.10. I am connecting to remote Oracle 11g database. After a lot of fiddling, I was able to display all details fetched from the Oracle database.

However, the pagination and searching is not working. It is throwing new Ajax requests to server, but the request has same parameter values. I am not sure why pagination/ searching is not working... All code seems to be working fine -- I have referred this link (https://datatables.net/development/server-side/php_oracle)...

Can anyone help please?

sagartoshniwal

Hi all,

I posted this question after no success at the end of 2 days of research... However, after posting it, I did one final round of search across the DataTables site and found a very simple answer to my problem...

'serverSide': false

This small line of code solved all of my troubles...

Thank team for such a marvelous component DataTables...

allan

Hi,

Good to hear you have it working with client-side processing. Server-side processing should only be needed when you have tens of thousands of rows.

The page you linked to notes:

This is a legacy documentation page and the methods described may not work with DataTables 1.10+.

That is indeed the case - it was designed for 1.9- and does not operate with the 1.10+ server-side parameters. DataTables would need to be used in legacy mode for it.

Allan

jrizzi1

allan,

should server-side processing be the option to go if your data does not necessarily reach 10,000+ rows, but has a complex query that takes a long time to get all data, but a short time to get if criteria is added to the query

allan

Possibly. To be honest, you would need to try the client-side processing option and then decide if its performance is acceptable for you or not. Between 10k and 50k rows is a bit of a grey area - server-side processing might or might not be better depending on a number of parameters.

Allan