|Large network traffic in comparission to SQL-Developer [message #917904]
||Thu, 20 September 2012 14:53
| Alexander Heffner
Registered: September 2012
I use EclipseLink to retrieve data from two tables. EclipseLink generates the following statement for that:|
SELECT t1.ID, t1.DIAGNOSELINKS, t1.EIGENTUEMER_QNUMMER, t1.GENERELL, t1.IDENTIFIKATOR, t1.ISAR_STATUS, t1.MODIFY_DATE, t1.MODIFY_USER, t1.TITEL, t1.VERSION, t1.VERSIONSUNABH_KOMMENTAR, t1.WICHTIGKEIT, t1.EIGENTUEMER_ID, t0.ID, t0.EMAIL, t0.FIRSTNAME, t0.KIFA, t0.LASTNAME, t0.MODIFY_DATE, t0.MODIFY_USER, t0.QNUMBER, t0.VERSION, t0.TEAM_ID
FROM T_USER t0, T_SP t1
WHERE ((t0.TEAM_ID = 4) AND (t0.ID = t1.EIGENTUEMER_ID));
The execution lasts many minutes and 6MB are transfered towards DB and 18MB back.
If I try to execute the same statement with the SQL-Developer, the execution only lasts several seconds and nearly nothing is transfered towards DB and only 6MB is transfered back. How can it be? Is there a problem with the driver (I use ojdbc14.jar)?
Thanking you in anticipation.
[Updated on: Thu, 20 September 2012 14:57]
Report message to a moderator
Powered by FUDForum
. Page generated in 0.02050 seconds