Depening on how you are obtaining a connection to the database, you may be seeing overhead in creating/destroying the object each time rather than poor SQL. Try running an ExplainPlan(I use the EP built in to Toad by Quest software) over each SQL statement that does any table joins, you may be missing a join etc.
Chris -----Original Message----- From: news [mailto:[EMAIL PROTECTED] Behalf Of Vic Cekvenich Sent: 22 July 2004 12:10 To: [EMAIL PROTECTED] Subject: Re: About Struts + JBoss preference issue Because Struts is a layered application, you can stress test the performance of your data layer by itself. If the DAO is slow, or the SQL is slow, then Struts can't serve it fast. So, test the performance of DAO layer. .V Koon Yue Lam wrote: > Hi ! My application has change from Struts + Tomcat to Struts + Jboss 3.X > > I create various struts Actions to deal with incoming request, in the > Action class, it preform remote lookup of session bean's home > interface and create, destory ... it. > > My session bean has an DAO attach to it to preform database related stuffs > NO entiy beans in my application since transaction is not a problem > and most DB query are read only > > The question is the speed, it is much slower when I request an Action > instead of directly request a servlet. Is it normal ? I don't mind a > little bit preformance tradeoff but I want to know the delay is caused > by Struts or something else. > > Any help? > > Regards --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] *********************************************** This e-mail and its attachments are confidential and are intended for the above named recipient only. If this has come to you in error, please notify the sender immediately and delete this e-mail from your system. You must take no action based on this, nor must you copy or disclose it or any part of its contents to any person or organisation. Statements and opinions contained in this email may not necessarily represent those of Littlewoods. Please note that e-mail communications may be monitored. The registered office of Littlewoods Limited and its subsidiaries is 100 Old Hall Street, Liverpool, L70 1AB. Registered number of Littlewoods Limited is 262152. ************************************************ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
