А если "напрямую" к серверу? Не пробовал? Интересно, что получится...
PHP код:
connection Con;
statement Stmt;
resultSet Res;
str SQLQuery = "SELECT A.ITEMGROUPID,A.ITEMID,SUM(B.AVAILPHYSICAL),C.INVENTDIMID,D.PRODDATE,D.INVENTBATCHID "
+"FROM INVENTTABLE A "
+"inner join INVENTSUM B on (A.ITEMID=B.ITEMID) "
+"inner join INVENTDIM C on ((b.inventdimid=c.inventdimid) and (B.AVAILPHYSICAL>0)) "
+"LEFT OUTER JOIN INVENTBATCH D ON ((C.INVENTBATCHID=D.INVENTBATCHID) AND (D.ITEMID = b.itemid)) "
+"GROUP BY A.ITEMGROUPID,A.ITEMID,B.ITEMID,C.INVENTDIMID,D.PRODDATE,D.INVENTBATCHID "
+"ORDER BY A.ITEMGROUPID DESC,A.ITEMID,B.ITEMID,C.INVENTDIMID,D.PRODDATE,D.INVENTBATCHID ";
Con = new Connection();
Stmt = Con.createStatement();
Res = Stmt.executeQuery(SQLQuery);
while (Res.next())
{
...
}
Вообще-то на менее сложных запросах работает медленно
