Editor - Limit amount of records in query
Editor - Limit amount of records in query
I'm using the inline editor to pull records from db, display and edit them.
I have about 200,000 records in DB, so server runs out of memory.
Iv'e seen here a few solutions how to limit the query , but non of them actually work.
What is the recommended way to limit query to only whats is shown on client side to avoid this problem?
Thanks
This discussion has been closed.
Answers
I'd suggest you use server-side processing. Editor's PHP and .NET libraries have server-side processing support built in - see this example.
If that doesn't work for you, can you post a link to a page showing the issue please.
Allan