I tested both MySQL and PostgreSQL under various loads, Actually got paid to do it. In the simple case where one process just stuffs data into the database with INSERT MySQL was about 4x faster in terms of INSERT/second
However if you have five or six processes that are doing lots of transactions, mixed INSERT and SELECT, MySQL grinds to a halt The trouble is locking. MySQL only lets one process at a table at a time so everyone else is shut out waiting. On a large PBX with high call volume you can't afford to have a table locked for 10 or 30 seconds while some guy does an ad-hoc join. PostgreSQL is more stable but can "only" do a few hundred INSERT per second on PC hardware vs. well over 1000/sec for MySQL. --- Matteo Brancaleoni <[EMAIL PROTECTED]> wrote: > I agree. postgres could be too slow if used into a big > system and you can't afford a rather good machine. > > mysql is very fast and simple. > > and I don't see where's the problem into the extraction... > a simple division could be done in any language, with any > program... > > matteo. > > Il mar, 2003-03-04 alle 20:27, [EMAIL PROTECTED] ha scritto: > > Why would anyone use such a big axe for a small problem, a trigger > to do simple math. Bah. > > > > MySql is perfectly suitable for CDR logging on any practical phone > system short of telco main office > > eqpt. > > > > > > Karl Putland wrote: > > > On Tue, 2003-03-04 at 11:57, Matthew S. Hill wrote: > > > > > >>I am pushing all the cdr info to a MySQL database on a separate > machine. > > >>I have noticed that the duration times for all calls are recorded > in > > >>seconds, by Asterisk. Is there a way to set the recorded call > duration > > >>to a decimal representation of minutes? ie 90 sec = 1.5 min. My > > >>extraction process would be a little simpler if the data dumped > into the > > >>database were minutes and not seconds. > > >> > > > > > > > > > Write a trigger for on insert or a view that converts sec->min. > Oh wait > > > your using MySQL. Use PostgreSQL ;) > > > > > > > > > > _______________________________________________ > > Asterisk-Users mailing list > > [EMAIL PROTECTED] > > http://lists.digium.com/mailman/listinfo/asterisk-users > -- > Matteo Brancaleoni <[EMAIL PROTECTED]> > Espia - Emmegi Srl > > _______________________________________________ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users ===== Chris Albertson Home: 310-376-1029 [EMAIL PROTECTED] Cell: 310-990-7550 Office: 310-336-5189 [EMAIL PROTECTED] KG6OMK __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
