hi! 700 records is not really a lot for a RDBMS like MySql...
Do you have proper DB indexes set? Did you map your relations correctly? Check your database first. I don't think you have an appfuse related problem in this case. best regards, Arthur On Sun, 2009-11-22 at 09:57 -0800, taltu wrote: > Hi, > > I make use of Appfuse 2.02 Struts 2 modular + jpa. > > I have big big problems with performance. I hope some of you can HELP me... > > My datamodel make use of the User domain object with 13 references. I have > enabled org.hibernate.SQL log and it seems like there are lot selects with > those references and I use the default ehcache settings. > > Each web-request make a lot (1-5) of userManager.findActiveUser(..). In > addition, when I get the User object a make use of deep copy the User object > and it's references using copy constructor instead of using deattached > objects on front end struts 2. > > Each time I uncomment a reference from the User object it become bit more > quicker. > > My application connects to a MySQL database with 700 users. When I have all > most all empty database with only samp-data.xml it is quick but with 700 > users and 13 domain objects it is slow every time a put a new reference from > user domain object. > > What do you think my problem is ? > > 1. The user object with 13 references to other domain objects configured > with JPA > 2. Caching configuration ? > 3. Multiple calls (1-6,7) to userManager.findActiveUser(...) > 4. ? > > I'm very very lost. What should I do ? > > -taltun > > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net For additional commands, e-mail: users-h...@appfuse.dev.java.net
