Posted by loosecannon_1@yahoo.com on 12/09/05 00:58

I believe it is blocking because I can send 12 or so via JDBC and they
all sit there waiting and then all return within milliseconds of each
other. It is not like one takes a long time and the others are real
fast. They all take 120 seconds or they all take 90. I did not run
sp_who because I was running then from a web client via JDBC. The same
behavior occurs whether I query the view or I query the tables directly
with the join. I can query once that returns quickly and then query
all 12 or so and they return in 3-4 seconds, which makes me think it is
either a caching issue or something to do with running 12 simultaneous
queries on the same table. The caching is problematic because I would
suspect one table to take a while and the rest to happen quickly unless
there is some delay I am not aware of. I will say that these tables
are replicated which I suspected make be an issue but I have other
tables that are just as large (15 yrs worth of data) and are replicated
and they have no problems. The ONLY difference is the join.

I guess I can look into how I can increase the cache size and see if
that helps.


Thanks for the help.

[Back to original message]