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]
