Would it just be easier to use a database system that managed concurent access better? Most all of them don't have trouble with this and don't require work-arounds like hot copies and so on.
--- [EMAIL PROTECTED] wrote: > I am always wary of allowing ad-hoc queries that may lock tables on a > production system. One > relatively easy way to avoid this issue is to use hotcopy to make a > read-only reporting database > that gets updated every x minutes. The other is to use replication > if you need an up to the second > copy. > > Bill > > Chris Albertson wrote: > > 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 > > > > > > _______________________________________________ > 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