Hi,
I've got a strange behaviour. I've got a very simple select statement

SELECT d.someVal from PoDetails d where d.val LIKE 'SOMETHING'

If I execute this against a very large Progress db table it takes about 65 seconds using Hibernate (tested with the HQL Editor in Eclipse) while the same query takes about 1-3 seconds with SquirreL (not due to caching, i've changed the search string to test that).

If I replace the LIKE with = the request time is only about 3 seconds with Hibernate. I know that LIKE is more expensive and that it doesn't make sense without % (my original query used 'BLA%') but it shouldn't be 65 seconds vs 3 seconds if the difference with SquirreL is hardly noticeable.

I tried to debug this using a packet sniffer but somehow no results are returned while the sniffer is active.

Any ideas what could be the problem?

Regards

Immo

You may want to try to log the statements sent to the database.

If Hibernate does not have any specific setting to turn logging on, you may do so by using an interceptor.

public class StatementInterceptor extends EmptyInterceptor {
private static Logger logger = LogManager.getLogger(StatementInterceptor.class)


public String onPrepareStatement(String sql) {
logger.debug(sql);
}

}

The HQL editor lets you see the generated SQL statement before you post it (quite nice for fine tuning your requests)
and I used the generated SQL in SquirreL.