Originally posted by vu lee:
how long did it take? Around 12 Seconds
how long did it take to execute and get your resultset?
Prepared statement.execute() took around 3-4 seconds
Did it take a long time on every single iteration? or just once for a while?
will have to dig into that
What was your sql statement? was it a nested or complex sql statement?
complex sql statement
How large is your table(s)?
some are considerably large
Did you data scatter on different partitions?
no
[ March 30, 2007: Message edited by: vu lee ]
but what i am thinking is this - is it possible that doing a complex select from across a lot of tables can slow it down?..basically when i try to find why did the resultset.next() take so much time..i see that a call to T4c*.unmarshall() is taking too much time
the above class is inside the driver jar
now, this leaves me with too possiblities
1) every iteration is taking it across the network - the unmarshall is for network data
2) internally the
jdbc driver will try to create objects before returning the result - the unmarshall call is basically deserializing the byte data into objects, since select is complex its slowing down
any concepts on these?
thanks for the help
OCMJEA/SCEA, SCDJWS, SCBCD 1.3, SCJP 1.4
My SCEA experience:http://javalogue.blogspot.com/