JDBC shows poor performance when selecting from a view
Posted on 2005-04-29
I'm not sure if this is the correct place to ask this question. If it's not, please direct me to the appropiate topic area.
I am using SQL Server 2000 with the latest JDBC drivers from Microsoft. I am executing a query where the I am selecting from a VIEW. It appears to be pretty straight forward but the response time is very slow. When I run the same query in Query Analyzer, the response time is very fast. Does anyone know of any issues with JDBC and selecting rows from a VIEW. Thanks.