Hi Michael, > This email is probably not the best medium to voice my concerns.
I am forwarding this to the user list, so that others can participate in this discussion. Make sure you don’t miss the replies either by subscribing or by following the archives: http://cayenne.apache.org/mailing-lists.html > That's when I decided to modify the source and it worked. Maybe you can post a diff with your change? > The site lists success stories, does that include success with legacy schemas? Absolutely. I have a bunch of those. > Having a terribly difficult time getting solid performance. I dump the > generated SQL to my console log and the simplest of queries take a few > seconds. If I throw in a join it's worse. Performance problem can be caused by many things. From SQL not hitting the indexes, to slow network, to large number of rows returned in a single query, etc. Could you provide more details - type and version of the DB, the number of rows returned, any special network details? Maybe a sample of your Cayenne log.. Andrus On Dec 17, 2013, at 9:31 AM, Michael Hatch <[email protected]> wrote: > To answer your question, I began with 3.0.2 but jumped to 3.2m1, but same > problem. That's when I decided to modify the source and it worked. I didn't > spend too much time on figuring out the problem and simply moved on. The site > lists success stories, does that include success with legacy schemas? Having > a terribly difficult time getting solid performance. I dump the generated SQL > to my console log and the simplest of queries take a few seconds. If I throw > in a join it's worse. The documentation says to prefetch, but that simply > creates multiple SQL statements which is not ideal. This email is probably > not the best medium to voice my concerns. I apologize. > > On Dec 17, 2013 12:15 AM, "Andrus Adamchik" <[email protected]> wrote: > Yep. SelectQuery(Class) is used in like 90% of everyone's code. This most > certainly works in all versions. > > Andrus > > On Dec 15, 2013, at 1:53 AM, Robert Zeigler <[email protected]> > wrote: > > > Hi Michael, > > > > I haven't tried grails, so I don't know whether there is any interaction > > there. > > But my code is littered with: > > > > SelectQuery q = new SelectQuery(SomeEntity.class); > > > > And it all works. > > > > So it sounds like there may be some issue with your environment? > > > > What version of Cayenne are you using? > > > > Robert > > > > On Dec 14, 2013, at 12/1412:24 PM , Michael Hatch <[email protected]> wrote: > > > >> Hello developers, > >> > >> I just started my first project utilizing cayenne (and grails). I was > >> surprised that following the tutorial was not working for me, by which I > >> mean I could not get a simple SelectQuery(Class) to return anything other > >> than null. I downloaded the source to the server jar and identified that > >> the non-default constructor did nothing. I modified the source to have the > >> non-default construct that accepts a class or a string to call "this()" > >> before calling init and all was well. I have no idea how you have had so > >> many releases and tutorial documentation stating that a simple > >> SelectQuery(Class) would return anything, when clearly it doesn't. >
