I have a grid that gathers its data from a PHP script, via an MSSQL database. This all works brilliantly, apart from the fact that the data is pretty darn large and can take up to 15 seconds to load…
To add a little bit of complexity to the issue, I also want to implement the filtering feature for the columns (contains, equal to etc…).
The issue I have is that I am not sure the best way to go about this. Obviously 15 seconds to load the data is not good enough and therefore I need to implement some sort of paging server side to prevent the full recordset being returned to the grid…
Can you advise a good way of achieving this?
Is there a way to handle the paging and filtering server side? Obviously this will require me to write the PHP (no issue here), I simply need to know how to pass the paging and filtering options as parameters to a url?
Something like:
E.g. http://www.example.net/items.php?page=1&pagesize=100&col1filter=contains&col1query=test...
Alternatively, if you have any other ideas of how I can achieve this, please advise me 🙂
Thanks in advance
