When a grid application is executed for the first time, Scriptcase runs the SQL query associated with the grid.
If the grid returns multiple pages, each time the user changes page, the initial query is executed again.
In practice, if the user switches pages five times, the query is executed five times.
This is absurd because it unnecessarily stresses the database.
Instead, the query result should be cached and presented to the user as they navigate between pages, without re-executing the same query over and over again.