Wonder if you've utilized OJB's proxy? Regards, Muliawan
On Tue, 19 Oct 2004 16:23:39 +0200, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hello Satish, > > > How do you know what SQL query, OJB is issuing ? (in your > > first email you > > said > > "I am using SQL Server and the query takes a couple of > > milliseconds when > > executed directly from the database.") > > > > using the following statement broker.serviceSqlGenerator > > ().getPreparedSelectStatement(oReportQueryByCriteria,broker.ge > > tClassDescriptor > > (class) > > > > Iam getting the sql text and running it in query analyser of MS SQL > > like Charles, I recommend to use p6spy to find out what > queries OJB actually performs and how long they take (the latter is > output by p6spy, too). Maybe OJB does more than you think because > it fills polymorphic collections or the like. > > Olli > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- "It is your attitude, and not your aptitude, that determines your altitude" --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
