1 Reply Latest reply on Nov 22, 2003 11:51 PM by takenori

    dynamic query performance

    takenori

      Hi,

      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.

      Takenori