Large network traffic in comparission to SQL-Developer [message #917904] |
Thu, 20 September 2012 10:53  |
Eclipse User |
|
|
|
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 10:57] by Moderator
|
|
|
Re: Large network traffic in comparission to SQL-Developer [message #918012 is a reply to message #917904] |
Thu, 20 September 2012 12:44  |
Eclipse User |
|
|
|
Are you sure that this is the only SQL statement that is being executed? 6MB being transfered towards the DB seems like there must be more going on than just this one statement. What query are you executing, and have you turned EclipseLink logging on to see if other queries get executed as a result of building up an entity with many relationships?
Best Regards,
Chris
|
|
|
Powered by
FUDForum. Page generated in 0.24610 seconds