Em 27/4/2012 15:11, Maury Markowitz escreveu:

> Well one way or the other the latency of the link does seem to be the most important factor in the problem I'm seeing.
>
> I have three ways to get at the data:
>
> 1) log into the remote server using RDP and run the queries locally. even the most complex ones complete in under a second

I use RDP for connections of internet, it's the best performance I can
get and no changes on my code.

>
> What's interesting is that there does seem to be some relationship between the number of joins and the performance. This makes me *suspect* that the driver is pulling tables to the local client and doing local JOINs.
>

Well....

I don't know the JDBC implementation, but I can assure you that the
JOINS are done server side. One thing, could be possible that some
library (hibernate or some other O/R mapping) are doing things behind
the scenes ?

see you !