Well it eats up a lot of cpu, it could be the code, it could be the database design. The database is only 181MB as of now.
I run this server solely as a database server with a 2Ghz Pentium IV and 1GB Ram and 7200RPM Haddrives. PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND 8180 root 15 0 79492 77M 1384 S 99.0 7.7 37554m 0 ibserver 13:11:47 up 83 days, 7:28, 1 user, load average: 2.92, 1.62, 1.58 It's a news site, at 1pm traffic is very low, but still the load is high. Don't take my word for it, test it yourself, for us, we decided to stay away from firebird and use postgresql/mysql instead. Cheers! ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 2:40 AM Subject: [plug] SAP DB+MySQL vs others > Hi Sherwin, > > We're looking at Firebird, after bad experiences with SAP. > > Sounds like you've used it - would you mind commenting some more on it, please? You seem not too impressed with it? > > Many thanks, > > David > > PS Please CC me in on the reply if you don't mind. > > > ---------------------------------------------------------------- > Me, I am pretty excited on the outcome of the partnership between MySQL and > SAPDB, in the opensource arena, this tandem will surely make a difference in > the database industry. I've been following MySQL since their 3.22.x branch > and I can tell that this database is really good and will continue to be. > > In my opinion with regards to superiority, Oracle will still be the most > superior of them all, because Oracle earns big bucks, and bulk of that money > goes to research and development. Firebird, hrmm with our experience with > their database, I am quite disappointed. Postgresql is pretty good, > especially with stability but it lacks the new mechanisms that MySQL have > like built-in replication, which we need for high-availability in our data. > Haven't tried SAPDB yet, well i tried but they only have rpms =( > > So I guess the comparison should be Free RDBMS to Free RDBMS and Commercial > RDBMS to Commercial RDBMS. > > PostgreSQL is the most stable for me. > MySQL is the fastest for me. > Oracle is the one with many features needed for the enterprise to run > massive mission critical data. Probably the best but depends on what you > really need. > SAPDB promising but not quite there. > Firebird/Interbase good well sort of. > > ----- Original Message ----- > From: "Winelfred G. Pasamba" <wingp at aup.edu.ph> > To: "Philippine Linux Users Group Mailing List" <plug at lists.q-linux.com> > Sent: Friday, July 25, 2003 4:26 PM > Subject: Re: [plug] SAP DB+MySQL vs others > > > > > > Ariz Jacinto said: > > > > > > will the SAP DB+MySQL database server tandem be > > > far superior compared to Oracle? Postgresql? Firebird? etc? > > > > > > > and which is the stablest database you've tried? > > -- > > Philippine Linux Users' Group (PLUG) Mailing List > > plug at lists.q-linux.com (#PLUG @ irc.free.net.ph) > > Official Website: http://plug.linux.org.ph > > Searchable Archives: http://marc.free.net.ph > > . > > To leave, go to http://lists.q-linux.com/mailman/listinfo/plug > > . > > Are you a Linux newbie? To join the newbie list, go to > > http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie > > > > > > > > -- > Philippine Linux Users' Group (PLUG) Mailing List > [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) > Official Website: http://plug.linux.org.ph > Searchable Archives: http://marc.free.net.ph > . > To leave, go to http://lists.q-linux.com/mailman/listinfo/plug > . > Are you a Linux newbie? To join the newbie list, go to > http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie > > -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
