List:General Discussion« Previous MessageNext Message »
From:David (SST - Adelaide) Logan Date:September 3 2004 12:51pm
Subject:RE: Fetch-on-demand
View as plain text  
Hi Martijn,

Perl certainly allows you to have multiple statement handles going on a
single connection. I'm not sure on the C API as I tend to stay with
Perl, this is with the proviso that I understand your email correctly
8-)

Regards

David Logan
Database Administrator
HP Managed Services
139 Frome Street,
Adelaide 5000
Australia

+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax



-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@stripped] 
Sent: Friday, 3 September 2004 10:08 PM
To: Rhino; mysql@stripped
Subject: Re: Fetch-on-demand


Hi,

> > Does MySQL support fetch-on-demand of resultsets?
> >
> > And if so, does it support multiple cursors fetching on the same
time
> > using the same connection?
> >
> > If so, is it thread safe?
>
> What do you mean "fetch-on-demand"? I've never heard this term before.
Since
> every fetch takes place when your program calls for it, isn't every
fetch
> already "fetch-on-demand"?

There are two ways to fetch a resultset -

1) fetch the entire resultset, close the handle (or whatever) and
cache the resultset locally so you can do your stuff.

2) keep the resultset open and fetch rows on a need-to-handle
basis. Sometimes also called a "server side cursor". Usually
forward only.

From my understanding, I believe MySQL can do (2), but my
question was if it can do (2) for multiple cursors at the same time,
or having a cursor open and execute other statements, on the
same connection.

And if so, if this is multi-thread-safe on a connection/network
level.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS
SQL
Server.
Upscene Productions
http://www.upscene.com


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
Fetch-on-demandMartijn Tonies3 Sep
  • Re: Fetch-on-demandRhino3 Sep
  • Re: Fetch-on-demandMartijn Tonies3 Sep
RE: Fetch-on-demandSST - Adelaide)3 Sep