We're experiencing a speed difference we can't explain. We've tried the following code in two circumstances:

Date start = new Date();
PersistenceManager manager = factory.getPersistenceManager();
PersistenceBrokerFactory.defaultPersistenceBroker().clearCache();
manager.currentTransaction().begin();
String filter = "registrationNumber == 2";
Query query = manager.newQuery(AircraftValue.class,filter);
Collection all = (Collection)query.execute();
Interator result = all.iterator();
Date end = new Date();

When packaged in a .war and invoked by a .jsp, the code executes in about 15 ms. When packaged in an ejbLoad() method on a BMP, it takes about 450 ms. The OJB.properties and registry.xml files are identical in both cases (copied from OJB 0.9.9), and we're using a datasource to SQL Server. Is this speed difference resulting from being executed inside a BMP transaction? Or is something else going on?
Thanks in advance,
Don
---



--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to