I have a query on SQL server, the table has 9,000,000 records, and has index. The reture results has only 1 record (select top 1). If I run query from SQL Analyzer, it’s very fast. However, if I query on WebMethods through jdbc adapter, it’s very slow. It takes me about 15 seconds to get the result.
At beginning, I thought it was a network problem. Then I try to run a query against a small table, and it’s fast.
My question is, if the delay response is because of the large table, it should slow on SQL Analyzer too.
SQL Analyzer WebMethods
large table fast (< 1s ) very slow (15 seconds)
small table fast fast
base on the above results, it looks jdbc adapter hold all results back to client side, and select the top 1 on clilent, but that’s not make sense at all.