Nusphere has a table type for mysql (Gemini) that has effective row level locking. I don't know which is best performance wise however (myisam/Gemini) for what you are trying to do.
www.nusphere.com Nihal -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Fabio Erri Sent: Tuesday, April 16, 2002 12:00 PM To: Andy De Petter Cc: [EMAIL PROTECTED] Subject: Re: (RADIATOR) Mysql table format for accounting Doesn't MyIsam table format locking all table during the insert? For accounting this is reccomandable? Andy De Petter wrote: > > Yes. :P > > -a > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]] On Behalf Of Fabio Erri > > Sent: dinsdag 16 april 2002 18:32 > > To: Andy De Petter > > Cc: [EMAIL PROTECTED] > > Subject: Re: (RADIATOR) Mysql table format for accounting > > > > > > > MyISAM works fine for us (~700 accounting records/sec during peak) > > > > 700 writing per second? Are you sure? > > > > > > > > > > > > -Andy > > > > > > > -----Original Message----- > > > > From: [EMAIL PROTECTED] > > > > [mailto:[EMAIL PROTECTED]] On Behalf Of Fabio Erri > > > > Sent: dinsdag 16 april 2002 14:50 > > > > To: [EMAIL PROTECTED] > > > > Subject: (RADIATOR) Mysql table format for accounting > > > > > > > > > > > > Hello to all, > > > > in your implementation of Radiator with mysql, which mysql > > > > table format > > > > have you choose for accounting one? Standart MyIsam or another. > > > > In your opinion, in case of heavy traffic (about 15 > > insert per second) > > > > which is the best choice? > > > > > > > > Thanks. > > > > -- > > > > Fabio Erri > > > > Elitel S.p.A. > > > > Tel. 02.44104.652 > > > > > > > > > > > > === > > > > Archive at http://www.open.com.au/archives/radiator/ > > > > Announcements on [EMAIL PROTECTED] > > > > To unsubscribe, email '[EMAIL PROTECTED]' with > > > > 'unsubscribe radiator' in the body of the message. > > > > > > > > -- > > Fabio Erri > > Elitel S.p.A. > > Tel. 02.44104.652 > > > > > > === > > Archive at http://www.open.com.au/archives/radiator/ > > Announcements on [EMAIL PROTECTED] > > To unsubscribe, email '[EMAIL PROTECTED]' with > > 'unsubscribe radiator' in the body of the message. > > -- Fabio Erri Elitel S.p.A. Tel. 02.44104.652 === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
