Thanks, and i will use the proper protocol for sending email from now on! Thanks, --mike
-----Original Message----- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 2:29 PM To: Rhodes, Mike Cc: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: Re: DBI--> threading and Informix Please send all email via the dbi-users list (or dbi-dev for internals). On Mon, Aug 19, 2002 at 10:33:31AM -0700, Rhodes, Mike wrote: > I saw some messages on threading and the DBI in the Archive mail area, and > noticed that DBI had some threading functionality. I am working on a > warehouse DB that rolls on and off millions of rows a day. Currently we > have a trigger that deletes all children from the child ( or detail ) table > when ever its parent is deleted from the parent ( or master ) table. I > wrote a program that grabs the min and max from the master to get a range > for a (today -30) then I delete that range out of the detail and then go and > do the same to the master. I saw no significant performance improvement. I > was then looking at fork to thread the program and break the range up, when > I noticed that DBI has treading capabilities. Very early days - and I certainly wouldn't recommend them for production use yet unless you like living very dangerously, solving very hard problems, and don't think you're job's at risk. Repeat after me: "There are *very* few situations where using threads with the DBI will buy you more efficiency than using multiple processes, even if threads worked reliably." > Is there documentation > somewhere I could read including but not limited to man pages? "perldoc DBI" is just about it. My tutorials on search.cpan.org may be worth a read. Tim.
