> Essentially there should be no difference in the
> query if its being run on the same file, as far as I
> know atleast.
I have monitored the SQL queries on the AS400 and the difference
between the simple query
SELECT *
FROM LIBRARY.OBJECT
WHERE column1 like 'Test%'
and the EJBQueryImpl is, that the EJBQueryImpl sends the following
SELECT *
FROM LIBRARY.OBJECT
WHERE (column1 LIKE CAST ('Test%' AS VARCHAR(32672) ))
This casting drives the CPU to nearly 95%.
[Message sent by forum member 'vjordan' (vjordan)]
http://forums.java.net/jive/thread.jspa?messageID=232889