[Developers] query timeouts
Scott Meyer
sm at metaweb.com
Wed Mar 4 00:19:28 UTC 2009
augusto callejas wrote:
> hi-
>
> i'm getting a consistent query timeout.
> my query is for the /type/link history for /people/person nodes
> that have been added since a certain time (and whose target
> type's are from a certain set).
>
> is there anything i can do to avoid the query timeout?
> perhaps change the limit size when i cursor? will that
> reduce the amount of time spent on the query?
> or is query time based on other factors that are
> query independent, but data size dependent?
Thanks for reporting the problem. We're looking into
the exact cause now.
In the meantime one optimization that frequently helps is
to use guids instead of ids. We have to look ids up, and
in the case of cursored queries over large collections id lookup
can add quite a lot of overhead.
-Scott
More information about the Developers
mailing list