Following your suggestion, I tried setting FlushModeType to COMMIT (the only other value supported with EJB3) as follows, but the query is as slow as before.
| public List< TestData > select( int accountId, Timestamp timeScheduled ) { | Query query = em.createNativeQuery( "select * from test_data where account_id = ? and time_scheduled > ?", TestData.class ).setParameter( 1, accountId ).setParameter( 2, timeScheduled ); | query.setFlushMode( FlushModeType.COMMIT ); | List< TestData > rows = query.getResultList(); | return rows; | } | If there was some unexpected flushing going on, wouldn't there be additional calls to the DB server? I have hibernate.show_sql=true and from the logs there are no other queries being executed other than the above select statement. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3988411#3988411 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3988411 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user