Re: How to change to using direct vs. cursor for queries within co

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Bob Heingartner wrote:

I need this functionality, because I am comparing a large amount of data between a MS SQL database and a non-MS SQL database, so I need to get all the data out of MS SQL 2005.

Gotcha. I might consider extracting the table via BCP or other
utility, and compare the data as a flat file...


"Joe Weinstein" wrote:


Hi. There is no way currently to set/change it on a running connection,
but there is also no reason why it couldn't, so that is a good feature
request.
However, what's the chance we can alter your applicaiton logic/architecture?
Selecting 100,000 rows from the DBMS to a JDBC client sounds at first blush to
violate the cardinal rule of RDBMS performance: Work on raw data where it is, in
the DBMS. If you want to make a rocking chair in Guam, you don't call the great
Northwest to send you timber. ;)
Joe



.