we have a scenario with JDBC receiver adapter to retrieve data based on criteria. Things are working properly, but we noticed the bad performance. After analyzing we found there are two SQL select statements sent to the database for every interface call, the first one is like select * from myTbale where 1<0; and the second one is the one we really want and we configured in PI (7.1 SP8). The first one is basically scanning hte table which causes performance issue, the second real one is actually very fast. So I jsut wondering how the first dummy statement with where clause of 1<0 gets sent to the database? Is it the JDBC adapter sends the dummy one to DB before sending the real one? This sounds silly to me, if now, how come everytime we run the interface, the dummy statement is sent before the real one?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.