In the module "Advanced Table Display and Management" I display sometimes a "mySQL view" (with several joins to multiple tables) instead of a table. This works fine was small data. But with a mySQL view with several 100-thousands of records the application is running slow.
Some tests learned that a query (the same like the mySQL view) with the added filtering is much faster than a filtering on the view (example: in the view filtering 2 seconds, in the query 0.1 milliseconds!)
Is it possible to create the same triggers from "Database/Advanced Find" in "Database/Database Query" (i.e. <From>, <To>, <Start From>, etc.) or is there some other fast solution?
For best results, use the Firefox browser..