What is ACID?
What is the BDB table type?
> -----Original Message-----
> From: Stephen Clouse [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, March 11, 2001 9:30 PM
> To: Mike<mickalo>Blezien
> Cc: [EMAIL PROTECTED]
> Subject: Re: RollBacks
>
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Sun, Mar 11, 2001 at 09:40:28PM -0600, Mike<mickalo>Blezien wrote:
> > This maybe more of a MySQL question than DBI, but I have a Perl
> script that does
> > 4 INSERTS into various tables. I know MySQL doesn't support
> Transactions, but
> > when the data is inserted into the tables and during the
> process a error is
> > encountered during an insert, is there an way to undo what was
> entered into any
> > other tables prior to the error. I normally use
> "$dbh->do($query); on all
> > UPDATES and INSERTS.
> >
> > any suggestion much appreciated.
>
> Suggestions: Postgre, Oracle, several others. MySQL is just now
> starting to
> figure out the need for transactions, and their current implementation
> definitely qualifies as a hack. If ACID is this important to you I would
> migrate to a more robust platform. You'll thank yourself later.
>
> The only other solution is to implement your own initial state logging and
> transaction system in your program, which is definitely more
> trouble than just
> finding a database that does things properly out of the box.
>
> - --
> Stephen Clouse <[EMAIL PROTECTED]>
> Senior Programmer, IQ Coordinator Project Lead
> The IQ Group, Inc. <http://www.theiqgroup.com/>
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP 6.5.8
>
> iQA/AwUBOqxe7wOGqGs0PadnEQLoqQCg+WIeH8ZzZx32QnW3ljUHBXsr56oAn1Ee
> smfnWs2BI3abl/vAJi265NRQ
> =2kaV
> -----END PGP SIGNATURE-----
>
