When i move the app from mysql to db28.1 , i got some problem about performance. I need to load a object with the specified name . it only spent 100 ms in mysql 4.1, but it will spent more than 600ms in db2 8.1
it's too slow to accept it. I try to use directly jdbc ,and get ony 30ms.

so , is anyone can help me ? below is my code and config file.it urgently.

hibernate version 2.1.2

father

[code]public class ControlObject {
private String id;
private String name;
private String detailName;
private String domainObjName;
private String parentId;
private String itemId;
private String objectId;
private List items;
--- GET

hi, is anyone can give me some advices?

You might want to try with lazy=true in the mapping:

<bag name="items"
cascade="none" inverse="true" outer-join="true"
order-by="id">

since I removd the bag tag, it still spent more then 500 ms.
I also try to load the controObject without assocication. it spent
400ms. it 's still not good.