On Wed, 9 Mar 2005 15:43:46 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > For some reason I didn't think PostgreSQL was for mission critical apps. I > don't think I have any reasoning behind it, just didn't think it was > "hardcore"...sounds like i might be wrong...i'll have to look into it more. > > Open source advantages are obvious, but aside from licensing and cost > factors, I believe speed, security, and stability are going to be the key > factors for us, whether open source or not. > > Thanks, > > Jon > > > ----- Original Message ----- > From: "Tzafrir Cohen" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Wednesday, March 09, 2005 3:18 PM > Subject: Re: [Asterisk-Users] OT: Best DB > > > On Wed, Mar 09, 2005 at 02:50:47PM -0500, [EMAIL PROTECTED] wrote: > >> I know this is a bit off topic but we are using Asterisk :) > >> > >> Since this list is full of tech gurus w/ all different sorts of > >> backgrounds, I thought I would get the best opinions here. > >> > >> We have several different switches and other telecom equipment at our > >> facilities which all have their own proprietary cdr platforms, which are > >> rather limited. The company I work for is looking to develop their own > >> in-house billing system that would combine cdr from all platforms and > >> bring > >> it into one big db, so we can do whatever we like w/ the data...billing, > >> invoices, reports, asr...etc... > >> > >> So my question is this.... > >> > >> What's the most stable, fastest & reliable database for this project? > >> Call > >> volume is about 8 to 10 million minutes per month, and we want to have 12 > >> months of cdr available at any given time, anything older can be archived > >> on tape. > >> So what's the best db...oracle, ms sql, informix, mysql or something > >> else? > > > > I'm not saying that it is the best or anything, I'm just wondering why > > it is ommited: > > > > PostgreSQL > > > > Comes well-integrated with your linux distro of choice, just like MySQL. > > Well-supoprted by Asterisk. > > > > I don't know exactly what type of application you'll have but generally > > it performs better than MySQL with more complex logic. > > > > Both MySQL and PostgreSQL have the obvious atvantage of being free of > > licensing headaches. E.g.: you'll never loose a week of development > > because the server licenses are delayed and you'll never have to change > > your design because client licenses are expensive. > > > > -- > > Tzafrir Cohen | New signature for new address and | VIM is > > http://tzafrir.org.il | new homepage | a Mutt's > > [EMAIL PROTECTED] | | best > > ICQ# 16849755 | Space reserved for other protocols | friend > > _______________________________________________ > > Asterisk-Users mailing list > > [email protected] > > http://lists.digium.com/mailman/listinfo/asterisk-users > > To UNSUBSCRIBE or update options visit: > > http://lists.digium.com/mailman/listinfo/asterisk-users > > --- > > [This E-mail scanned for viruses by Declude Virus] > > > > > > --- > [This E-mail scanned for viruses by Declude Virus] > > _______________________________________________ > Asterisk-Users mailing list > [email protected] > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
PostgreSQL 8.0 would be my recommendation. The new features that were put into production with this latest release are impressive. Replication, point-in-time recovery, transactions and many other features make this database outshine mySQL (even with innoDB) I have several database applications which each average over two million queries a day. mySQL works just fine except it degrades to full-tablespace scans too quickly, whereas postgreSQL does a much better job of optimizing more complicated queries. Even when postgreSQL resorts to a full table scan, it still seems to return the results quite a bit faster than mySQL. Everything else is the same (same OS, computer, processor, RAM, hard-drive, etc). Anything new that my team produces will definately be running on postgreSQL. Just my $.02. _______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
