I'm experiencing some latency, which I think is occurring due to a large number
of tables in my DB.
The first domain object that is loaded on the home page loads very quick. But
the second loads very slow.
I notice there is a difference in the column validation query -
The first query has a table name in the 'where' clause.
The second query contains 2 objects/tables in the debugging statement, and
there is no 'where' clause in the SQL.
Hangs at this line while debugging -
Loading column info for table(s) "OBJECT_A, OBJECT_B" in Catalog "", Schema
""
It will eventually return, but it takes about 9 minutes.
I'd like to speed this up, maybe by forcing the column validation to use the
table name every time, or some other way.
Any thoughts?
Jeremy D. Branham
Technology Architect - Sprint
________________________________
Learn more on how to switch to Sprint and save 50% on most Verizon, AT&T or
T-Mobile rates. See sprint.com/50off<http://sprint.com/50off> for details.
________________________________
This e-mail may contain Sprint proprietary information intended for the sole
use of the recipient(s). Any use by others is prohibited. If you are not the
intended recipient, please contact the sender and delete all copies of the
message.
