server-side odbc oracle
server-side odbc oracle
Hi All,
I have a form
search.php and its posts to results.php
the search box just passes the values in the url and is collected by the results.php using get and runs a query against the oracle database and then loops through to display the records. Datatables takes care of the table and the pagination.
Now i can display 2500 rows quite nicely and and it doesn't take too long but some queries can be 20,000-100,000 rows which IE starts to display the javascript not responding....i can click through it and it will eventually load.
i've done a bit of reading and i realize that i need server-side querying enabled to make this work smoothly but i really don't understand how to make it work.
Can someone please dumb it down for me?
Or provide a basic 3 page example i can sift through to work it out, i'm struggling with the documentation i've a bit of a n00b when it comes to this sort of stuff.
thank you.
I have a form
search.php and its posts to results.php
the search box just passes the values in the url and is collected by the results.php using get and runs a query against the oracle database and then loops through to display the records. Datatables takes care of the table and the pagination.
Now i can display 2500 rows quite nicely and and it doesn't take too long but some queries can be 20,000-100,000 rows which IE starts to display the javascript not responding....i can click through it and it will eventually load.
i've done a bit of reading and i realize that i need server-side querying enabled to make this work smoothly but i really don't understand how to make it work.
Can someone please dumb it down for me?
Or provide a basic 3 page example i can sift through to work it out, i'm struggling with the documentation i've a bit of a n00b when it comes to this sort of stuff.
thank you.
This discussion has been closed.