Hello! I have a table with some 6000 rows and I have to make a query to select some 20 rows. I have read this thread: http://www.mail-archive.com/[EMAIL PROTECTED]/msg00626.html from the ojb-user list, which says, that first all rows of a tabel are read into memory (in my understanding...)
In fact, my query takes quite a while to be finished (3-5 secs); this is my code: manager = factory.getPersistenceManager(); manager.currentTransaction().begin(); Extent extent = manager.getExtent( Class.forName( myClass ) , true); query = manager.newQuery( extent , filter ); result = (Collection)query.execute(); manager.currentTransaction().commit(); Any hints on how to build a fatser query with ojb and jdo? Thanks a lot for your help Bastian ______________________________________________________________________________ Erdbeben im Iran: Zehntausende Kinder brauchen Hilfe. UNICEF hilft den Kindern - helfen Sie mit! https://www.unicef.de/spe/spe_03.php --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
