Re: SelectMethod=cursor and SelectMethod=direct
- From: "Alin Sinpalean" <alin@xxxxxxxxxxxxx>
- Date: 1 Apr 2005 09:40:46 -0800
Joe Weinstein wrote:
> The driver *should* not have to do so.
It should not. But it does. According to the "Microsoft SQL Server 2000
driver for JDBC User Guide and Reference" page 27: "You should avoid
using direct when executing queries that produce a large amount of
data, as the result set is cached completely on the client and
constrains memory."
Alin,
The jTDS Project.
.
- Follow-Ups:
- Re: SelectMethod=cursor and SelectMethod=direct
- From: Joe Weinstein
- Re: SelectMethod=cursor and SelectMethod=direct
- References:
- Re: SelectMethod=cursor and SelectMethod=direct
- From: Joe Weinstein
- Re: SelectMethod=cursor and SelectMethod=direct
- From: Frank Brouwer
- Re: SelectMethod=cursor and SelectMethod=direct
- From: Joe Weinstein
- Re: SelectMethod=cursor and SelectMethod=direct
- Prev by Date: Re: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
- Next by Date: Re: SelectMethod=cursor and SelectMethod=direct
- Previous by thread: Re: SelectMethod=cursor and SelectMethod=direct
- Next by thread: Re: SelectMethod=cursor and SelectMethod=direct
- Index(es):
Relevant Pages
|
Loading