RE: Performance Issue on lookup on a table
"Ferrer, Eric" <[email protected]>
| Newsgroups | gmane.comp.jakarta.ojb.user |
|---|---|
| Message-ID | <[email protected]> |
Just to add it appears to work when passing a straight SQL query versus using the persistable method. -Eric -----Original Message----- From: Ferrer, Eric [mailto:[email protected]] Sent: Thursday, February 01, 2007 4:57 PM To: OJB Users List Subject: RE: Performance Issue on lookup on a table Sorry Accidently hit send. What I was saying the query generate looks like this SELECT TOP 1 A0.SERIAL_NUMBER,A0.AD_ID,A0.LIC_NUM,A0.RECEIVED_DTIME,A0.LIC_ST,A0.LIC_ TYPE FROM MY_LIC_TLB A0 WHERE ((A0.LIC_NUM = '1236713' ) AND A0.LIC_ST = 'DD' ) AND A0.LIC_TYPE = 'NORMAL' When I run it in the sql management tool it comes back in less than 20 seconds, however via ojb it varies between 5 and 7 minutes. The table has 3 gigs of data. Any ideas what can be the difference? We do lots of similar calls and this is the first one we ever experienced this with. Thanks -Eric -----Original Message----- From: Ferrer, Eric [mailto:[email protected]] Sent: Thursday, February 01, 2007 4:52 PM To: OJB Users List Subject: Performance Issue on lookup on a table I am experience an issue with an OJB query using a persistable object. Basically its taking 7 minutes to return on the call getObjectByQuery. When I run the query --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]