On Apr 20, 2005, at 10:41, tnaki..ofthome.net wrote:
> My devel. environment: Postgre 8.0.x, JDK 1.5, Win. 2k
>
> I have a query that runs in less than a tenth of a second when I run
> it directly, by using the admin interface.
> When I run it using cayenne, however, it literally takes 2 minutes -
> what's more interesting is it's just one out of several queries all of
> which run fairly fast (and all run on views, rather than tables).
> Furthermore, it's a very simple query and it returns very little data.
Could you give us some more info? Perhaps output from cayenne logging?
Have you done any profiling to see where the time are spent?
- Tore.
This archive was generated by hypermail 2.0.0 : Wed Apr 20 2005 - 07:14:32 EDT