Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Large network traffic in comparission to SQL-Developer
Large network traffic in comparission to SQL-Developer [message #917904] Thu, 20 September 2012 10:53 Go to next message
Alexander Heffner is currently offline 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 10:57]

Report message to a moderator

Re: Large network traffic in comparission to SQL-Developer [message #918012 is a reply to message #917904] Thu, 20 September 2012 12:44 Go to previous message
Chris Delahunt is currently offline Chris Delahunt
Messages: 995
Registered: July 2009
Senior Member
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
Previous Topic:Foreign key violation because jointable row is not removed
Next Topic:Location of jaxb.index for JAXB
Goto Forum:
  


Current Time: Sat Apr 19 08:47:22 EDT 2014

Powered by FUDForum. Page generated in 0.01963 seconds