Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-25 Thread Shubbis
ManyToOne to a Region. Now I realize that this is quite abstract, but I hope you get my point. Shubbis Hi Shubbis, Glad to help. Some comments inline. On Sun, Mar 22, 2009 at 8:39 AM, Shubbis wrote: > > Hi Michael and everyone else involved! > > I greatly appreciate the efforts put

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-22 Thread Shubbis
t to work just as much as you guys. Like i said to Michael, his suggestion increased the performance and might be the solution, but I can not be sure untill i get back to the office. I will of course reply with updates. Shubbis Kevin Sutter wrote: > > Shubbis and Nitish, > Thanks for yo

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-22 Thread Shubbis
ard time formulating coherent replies as this is my second language and I'm quite new to all of this (OpenJPA/JPA etc..). Thanks again! Shubbis Michael Dick wrote: > > Hi all, > > As Paul pointed out privately I didn't indicate which versions of OpenJPA > I &g

RE: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-19 Thread Shubbis
mes slower than Hibernate, EclipseLink, iBatis and regular JDBC when persisting entities with many relations. Clearly this is not the kind of results I was hoping for and I'm quite perplexed as to what to do. Shubbis Nitish Kumar wrote: > > Hi subbis, > If I let the it

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-19 Thread Shubbis
Yes, we checked the SQL and I have also tried with different joinsyntax.. no luck :/ Thanks though. Shubbis Georgi Naplatanov wrote: > > Hello Shubbis. > > Did you check generated SQL ? > > OpenJPA has property about how to perform joins. > > My be with traditional

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-19 Thread Shubbis
Hi, thanks for the suggestion, but we are aware of that, and we have turned it off on EclipseLink to even the playingfield. Today we found a new problem with OpenJPA. When running the following method we get a similar type of performance hit and an Exception after the first run. Note: This except

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-18 Thread Shubbis
And a link to the complete project, with all jar files etc in the lib folder. http://files.sharetoad.com/?id=f89de9caa6 OpenJPA project -- View this message in context: http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2496066.html Sent fro

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-18 Thread Shubbis
still not close to good enough.. I just don't get it! Anything..? Shubbis Paul Copeland wrote: > > What is different abut your laptop at home vs. multiple computers at > work? Are they all connected to the same network? > > On 3/17/2009 11:30 AM, Shubbis wrote: >>

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-17 Thread Shubbis
if/when I find anything. Shubbis Paul Copeland wrote: > > What is different abut your laptop at home vs. multiple computers at > work? Are they all connected to the same network? > > On 3/17/2009 11:30 AM, Shubbis wrote: >> Ok, I still dont know what the problem is, bu

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-17 Thread Shubbis
he root of the cause, since we have tried it on multiple computers at work, but at least this confirms that the project itself is working. Btw Pinaki, your plugin works perfect with MyEclipse 7.1.1 aswell. FYI. Nice work ;) Shubbis PS: adding the project if anyone wants to see. This is without a

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-17 Thread Shubbis
. See if maybe its my enhancing thats the problem. Shubbis -- View this message in context: http://n2.nabble.com/Slow-performance-with-OpenJPA-when-selecting-from-a-ManyToMany-relation.-tp2466994p2491667.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-17 Thread Shubbis
Yep, I sure have.. Shubbis Pinaki Poddar wrote: > > I do not find anything obvious in the tests that can cause the slowdown. > Now the usual suspect: Have you enhanced Storeage/WeraHouse classes at > build-time? > > -- View this message in context: http://n2.nabble.co

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-17 Thread Shubbis
Shubbis Shubbis wrote: > > Hi again, > > Thanks for your patience and I am sorry for the late reply, but we are > only stationed at the offices three days a week. > > I must admit i don't understand what you mean by test harness. If

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-17 Thread Shubbis
Hi again, Thanks for your patience and I am sorry for the late reply, but we are only stationed at the offices three days a week. I must admit i don't understand what you mean by test harness. If you could explain i will gladly post it. In the meantime I have created a new project and added Ope

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-12 Thread Shubbis
l mysql installation and the results are similar, actually a bit slower.. Jeremy Bauer wrote: > > Hi Shubbis, > > Does your measurement include the time it takes to create the entity > manager > factory and/or entity manager or are they created before you execute the > find

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-12 Thread Shubbis
tweaks and possibilities we decided to leave them all default so we could have an even comparison. Obviously with the exception of enhancing files for OpenJPA. We really appreciate the help btw! :) Kevin Sutter wrote: > > Shubbis, > Darn, I thought it was going to be an easy "lack of enhancem

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-12 Thread Shubbis
Hi Kevin, Thanks for the reply! We are enhancing the files. I have an Ant script enhancing the files before every run of OpenJPA, so that is not the problem. Although it did give me strange results the first time I tried openjpa and did not enhance ;) -Shubbis Kevin Sutter wrote: > &

Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-12 Thread Shubbis
First post so bare with me, and I've search for quite a while and not found any answers. I'm working on a school project where we are testing performance with different ORM's compared to JDBC and I'm having a big issue with OpenJPA when using a ManyToMany relation. We're trying to do a simple se