My dynamic query is very slow.
Any idea to improve this?
My dyanamic query is very simple like:
SELECT OBJECT(k) FROM Kokyaku AS k
OFFSET 1200 LIMIT 20
This Strategy is "on-find" and eager-load-group is "*".
The selected columns are 53.
This takes 700 ms on average to fetch data.
I don't use parameters like "?1".
Each WHERE, ORDER BY, OFFSET&LIMIT clause are dynamicaly created.
Database is "MySQL 3.23".
Any caching don't seem to be hit.
Thanks in advance.
The key, OFFSET and LIMIT, doesn't limit the data
retrieved from databases.
I changed the strategy to "on-find",
and page-size to "20".