I remember talking to Uri about Stem. Looks like a nice application of Stem. Delegate the work to 3 different stem cells and posts the results to another stem to sync the results. I believe Stem works very well with DBI interface.
---Closing information gaps----- Ranga Nathan, Reliance Technology >>SEVIS solution now! http://goreliance.com >>Live demo at http://any2xml.com/docs/timesheet_demo.shtml<< >>Get free COBOLExplorer at http://goreliance.com/download-products << > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:boston-pm-admin@;mail.pm.org] On Behalf Of Charles Reitzel > Sent: Monday, October 21, 2002 12:21 PM > To: William Goedicke > Cc: [EMAIL PROTECTED] > Subject: Re: [Boston.pm] Fork SQL selects and inserts > > > Why not do it the simple way: just invoke 3 scripts from the > shell (or the > same script 3 times w/ different args)? No fork necessary. > > The approach scales well. For example, if you are going to > pull in data > from multiple sources, it is probably better to decouple the > error handling > (and notification) for each source. If you are going to do this on a > regular basis, cron is still a good way to manage a large number of > periodic batch jobs. > > take it easy, > Charlie > > > At 08:31 PM 9/24/2001 -0400, William Goedicke wrote: > >Dear Y'all - > > > >I'm working on a problem right now that involves accessing > several (4 > >so > >far) different databases simultaneously and I thought I'd > solicit your > >input on efficiency and performance. > > > >The task is to query 3 MySQL databases two of which are across the > >internet (10+ hops) with selects that retrieve a few > thousand records and > >then do an insert of a transformed version of those records into a > >local Oracle database. > > > >Finally the question, my plan is to launch seperate concurrent > >processes > >to execute the selects to the various MySQL databases and > I'm looking for > >an intelligent way to code that in perl. The moron > >way (always my first choice) would be to system('perl > my_prog...'), but > >that's obivously silly. It seems to me that there should be > some elegant > >way to fork perls that simply execute the statement handles > that I've > >pre-prepared using DBI. > > > >Please be aware that I'm grateful for any assistance you may > offer and > >that I'll be using the results in the workplace. In fact I > may include > >some of your comments in the documentation (anonymously by > default). I > >didn't want to do that without informing you. > > > > Yours - Billy > > > _______________________________________________ > Boston-pm mailing list > [EMAIL PROTECTED] http://mail.pm.org/mailman/listinfo/boston-pm > _______________________________________________ Boston-pm mailing list [EMAIL PROTECTED] http://mail.pm.org/mailman/listinfo/boston-pm
