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]
