Hello again @mevdschee,

Thank you again for developing this amazing API and dedicating your efforts to it.
Right now we have four machines (portable water purification) running.

For all kinds of logging every machine has a MySQL server and webserver running. Every 5 seconds a log is added.
Monitoring is done through a locally running website after logging on the machine.

At this moment we have around 1.000.000 records in the LOG table. When I want to retrieve the latest logging results I use a query as this:

/api.php/records/log?order=date,desc&page=1,720 (720 is for hone hour of log entries) and this takes around 3 seconds. What I don't understand is why this seems independent of the page size (1000 in this example). The response time for 72, 7200 or 72.000 as page size it is the roughly 3 seconds.
I added an index to the date column already (otherwise response time would be minutes).

Is there a way to speed up response times?

Looking forward to hearing from you.