Re: InnoDB / Transactions question

2010-05-17 Thread Michael Stroh
Thanks for the clarification. Michael On May 17, 2010, at 2:28 PM, Michael Dykman wrote: > MyISAM does not support transactions so it is inherently in > 'autocommit mode' all the time. You will run into this with any > transactional database, be it InnoDB, Falcon, or Oracle and DB2 > installat

Re: InnoDB / Transactions question

2010-05-17 Thread Michael Dykman
MyISAM does not support transactions so it is inherently in 'autocommit mode' all the time. You will run into this with any transactional database, be it InnoDB, Falcon, or Oracle and DB2 installations for that matter. For many classes of application, avoiding autocommit and explicitly creating a

InnoDB / Transactions question

2010-05-17 Thread Michael Stroh
Hello, I'm currently writing a python program that scans some web directories and then stores some information in a local database. I'm playing with using InnoDB for this application as a test bed for using InnoDB in further applications, but I'm running into a couple issues. When I try to writ

Re: Transactions question

2004-10-14 Thread Stuart Felenstein
d write it to the > database. > All the tables for insertions are innodb so i'm > going > (or trying too) with the "one stop shop" approach - > transactions. > > Question: > The first table I write too has as it's first column > an auto-inc int. This "

Transactions question

2004-10-14 Thread Stuart Felenstein
I'm in the midst of writing out some code that will take data from a huge form and write it to the database. All the tables for insertions are innodb so i'm going (or trying too) with the "one stop shop" approach - transactions. Question: The first table I write too has as

RE: Multi-user / transactions question..

2004-04-21 Thread Jeremy Smith
5 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Multi-user / transactions question.. Jeremy Smith said: > > A typical auction lasts around > 90 minutes, and consists of a whole lot of furious refreshing of the > auction board by the participants since each player only h

Re: Multi-user / transactions question..

2004-04-21 Thread Jochem van Dieten
Jeremy Smith said: > > A typical auction lasts around > 90 minutes, and consists of a whole lot of furious refreshing of the > auction board by the participants since each player only has a 2 > minute clock. You might wish to look into using a different mechanism for this so you can push the lates

Multi-user / transactions question..

2004-04-20 Thread Jeremy Smith
Hi everyone, Some quick background before I get to my question: I have developed a fantasy football game that is based on an auction style format. In any given game there are a consistant number of players, usually 10 or 12. There can be more than one game taking place at the same time on the

Multi-user / transactions question..

2004-04-20 Thread Jeremy Smith
Hi everyone, Some quick background before I get to my question: I have developed a fantasy football game that is based on an auction style format. In any given game there are a consistant number of players, usually 10 or 12. There can be more than one game taking place at the same time on the

Multi-user / transactions question..

2004-04-20 Thread Jeremy Smith
Hi everyone, Some quick background before I get to my question: I have developed a fantasy football game that is based on an auction style format. In any given game there are a consistant number of players, usually 10 or 12. There can be more than one game taking place at the same time on the s