|
Home > Archive > SQL Server JDBC > March 2006 > Re: How to change to using direct vs. cursor for queries within co
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: How to change to using direct vs. cursor for queries within co
|
|
| Bob Heingartner 2006-03-13, 8:23 pm |
| 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.
"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
>
>
| |
| Joe Weinstein 2006-03-13, 8:23 pm |
|
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...
[color=darkred]
>
> "Joe Weinstein" wrote:
>
>
|
|
|
|
|