in reply to Re: DBI multicasting?
in thread DBI multicasting?

Agreed, this should be fine for the extraction of data - But if the client is looking submitting or changing data to the databases, then the best method would be for the wrapper to have two (or more) concurrent DBI handles with DBI->autocommit disabled. The DBI->commit method could be called after execute statements to all database handles had been issued. While this method isn't as good as internal synchronisation at the database level, it should suffice for most circumstances.

 

Ooohhh, Rob no beer function well without!

Replies are listed 'Best First'.
Re: Re: Re: DBI multicasting?
by ask (Pilgrim) on Nov 19, 2001 at 16:15 UTC
    So what do you do if the commit fails on the second database handle?

    In any case it's hard to give advice on something like this without knowing more details about what kind of application the system needs to support.

     - ask

    -- 
    ask bjoern hansen, http://ask.netcetera.dk/   !try; do();