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 !
