Server-side processing with php, oracle(SQL) and JOIN

benjaminmue

Hi there
I'm relatively new to php and SQL. For a project that I'm involved with I have to set up a website that accesses a Oracle Database. This Database has over 50'000 entries and with the code that I'm using now it takes a long time to load data or doesn't even load at all.
Because of this I would like to implement Server-side processing.
Yes, I have seen this Page: http://datatables.net/examples/server_side/simple.html and I tried to implement it into my project.
After several misguided and non working attempts I stopped and went back to my working code.

http://pastebin.com/KrYEAR7r
and
http://pastebin.com/L5nRsKze

If I uncomment the Server-side part of the code in app.js I get the following error: http://s10.postimg.org/gpeiw95c9/error.png

What I'm trying to achieve is that the data loads faster. Otherwise said: I'm trying to implement Server-side processing. If I now search for "US" in my search box, it does not load at all because there is too much data. If I search for Portugal "PRT" it take around 3 seconds to load the data and I can continue searching or filtering the found data using the datatables search functions. The bigger the found data is the longer it takes to "reload" the page.
Because php and oracle in combination is not well documented and I can't find a example to work with, I'm writing this in hope of somebody having a example or knowledge of how to do it.

Help would be much appreciated. If there is some information that is missing please let me know and I will try to provide it.

Thank you very much

Benjamin

mpuyishere

Hi Benjamin.
We have a same problem with server side oracle+php. I agree that php and oracle in combination is not well documented. Maybe because oracle for comporate is not free (not open source like mysql). So just a few to share it on the internet.