My experiences with Firebird wasn't really exciting, our setup with firebird eats up the whole cpu when querying data, the database size now is about 200Mb, sure it has those bells and whistles of an almost true ACID rdbms but it's slow, well in our case.
In the Firebird db that you're using, how big is it now? hrmm i guess if your db is bigger, then there's something wrong in my setup, well optimization wise i guess. Sherwin Ang ----- Original Message ----- From: "Andy Sy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 14, 2003 3:39 PM Subject: [plug] Re: does mysql scale > > Message: 2 > > From: Hagibis Fan <[EMAIL PROTECTED]> > > Subject: [plug] does mysql scale > > > > are there any mysql users in here? I am thinking > > of getting an mysql certification (to improve my > > resume--could be useful later). most of the > > people in my day job dosnt take it seriously, > > but i *really* do like it. > > > > do you use it in a serious > > application, and like how much rows do you estimate > > on your largest table? I have it on my > > webserver at around 20k rows but i dont know how it > > would behave in large applications. > > > > jondz > > MySQL scales and scales _really well_, however it > lacks many of the niceties that have come to be > considered essential in 'real' DBMSes, working > foreign keys, subselects, triggers, SPs, etc... > > You are going to have to do a lot of extra stuff > to work around their absence. But if your app > can do without most of these and you need MySQL's > blazing speed, then MySQL makes for an extremely > effective tool. > > I've become a Firebird fan lately, but for an application > like say, a high traffic web forum (which has relatively > simple tables), I'd probably still stick to MySQL (though > since I'm using PHP ADODB for the one I'm developing > right now, switching to Firebird will be much less > painful). > > MyISAM tables are really easy to maintain and are quite > fast (on simple queries only). InnoDB has more heavyweight > features but seems like a lot more pain to work with. > > Anyone out there have good things to report wrt to InnoDB? > _ > Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph > To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] > > Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph > > To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED] > > _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
