This project is read-only.

Parallel Fox: Use for data

Aug 11, 2011 at 10:37 PM

Does anyone know of a way to use Parallel Fox (PF) to open multiple data tables in SQL?  I have a routine that opens 20 tables (cursors using SPT).  I would like to use PF to speed up that process.  However, I understand that the workers don't share the data environment.  Any ideas?

Mike

Aug 12, 2011 at 5:49 PM

Hi Mike,

Are these read-only cursors, or do you need to write back to the tables using TableUpdate, etc.?  If read-only, you could open each cursor in a worker and use Worker.ReturnCursor() to return it back to the main process.  Note that you'll have to open a SQL connection in each worker.

Joel

Aug 12, 2011 at 6:25 PM

Joel,

Nope.  I need full readwrite cursors...

Mike

Aug 13, 2011 at 4:04 PM

Sorry, I can't think of a way ParallelFox can help you with that.  Using asynchronous processing for the queries comes to mind, but I believe that would require a separate connection for each cursor, and I doubt it would be faster anyway.

Joel