469,890 Members | 2,121 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,890 developers. It's quick & easy.

Help with JDBC Driver

Hello all,

I have a question about the SQL Server JDBC driver. I was wondering if
anyone knows what the default prefetch size is (in number of rows).
Also, does anyone know if an entire packet is sent (i.e. padded with
null values) if there is not enough data to fill it?

Thanks for your help!

ty
Jul 23 '05 #1
2 2170
Ty,

The default fetch size with the MS driver is 1 in cursor mode and
"cache everything" in direct mode. These are basically the worst
choices possible: in cursor mode a fetch size of 1 will cause a request
to be made for each retrieved row and in direct mode there is normally
no need to cache the results to memory, they can be read on an "as
needed" basis.

With jTDS (of which I'm a developer) the default fetch size is of 100
rows for server side cursor based ResultSets (i.e.
scrollable/updateable) and no prefetching is done for direct executions
(i.e. fire hose cursors).

Please note that with both drivers you can set the fetch size you want
instead of the default.

Alin,
The jTDS Project.

Jul 23 '05 #2
Hi Alin,

Thanks for the information!

ty

In article <11**********************@z14g2000cwz.googlegroups .com>,
Alin Sinpalean <al**@earthling.net> wrote:
Ty,

The default fetch size with the MS driver is 1 in cursor mode and
"cache everything" in direct mode. These are basically the worst
choices possible: in cursor mode a fetch size of 1 will cause a request
to be made for each retrieved row and in direct mode there is normally
no need to cache the results to memory, they can be read on an "as
needed" basis.

With jTDS (of which I'm a developer) the default fetch size is of 100
rows for server side cursor based ResultSets (i.e.
scrollable/updateable) and no prefetching is done for direct executions
(i.e. fire hose cursors).

Please note that with both drivers you can set the fetch size you want
instead of the default.

Alin,
The jTDS Project.

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Axel Dachtler | last post: by
reply views Thread by Nils Valentin | last post: by
2 posts views Thread by Raquel | last post: by
1 post views Thread by sid_mulpuru | last post: by
3 posts views Thread by Anoop | last post: by
2 posts views Thread by dmstn | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.