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:[EMAIL PROTECTED] Sent: Friday, 3 September 2004 10:08 PM To: Rhino; [EMAIL PROTECTED] 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
