The insert happens very fast, as we tend to keep the amount of records in those tables *very* small. Records are only temporarily kept there, and usually there are not more than a couple of thousand records in there.
a > -----Original Message----- > From: Fabio Erri [mailto:[EMAIL PROTECTED]] > Sent: dinsdag 16 april 2002 20:00 > 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.
