ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fabio Insaccanebbia" <finsaccaneb...@gmail.com>
Subject Re: Search screen : HOW TO
Date Tue, 12 Sep 2006 16:22:42 GMT
Just a couple of questions..

Is the pmp.MANUFACTURE_PROCESS_ID field indexed?
Are the field values equally distributed?

If the answers are (yes, no) and you're using Oracle, maybe you're having a
problem with a skewed index.

Added each "dynamic" line in one by one, and it was ok until I added
> pmp.MANUFACTURE_PROCESS_ID back in, then it jumped from 1 sec to many
> minutes.
> If I run it in TOAD it is fine, 1 sec, the DB definition for this field
> is an Integer, its an Integer in the CustomObject class, and the sqlmap
> has it as an Integer.

View raw message