Large network traffic in comparission to SQL-Developer [message #917904] |
Thu, 20 September 2012 14:53 |
Alexander Heffner Messages: 1 Registered: September 2012 |
Junior Member |
|
|
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.01943 seconds