Re: Which RDMS is best?

[ This is a repost of the following article: ] [ From: "Darin McBride" <dmcbride@nospam.tower.to.org> ] [ Subject: Re: Which RDMS is best? ] [ Newsgroups: alt.comp.databases,comp.database,comp.database.ingres,comp.database.oracle,interbase.public.general,interbase.public.linux,linux.postgres ] [ Message-ID: <qzpoevqrgbjregbbet.foz08sb.pminews@news.mtag1.on.wave.home.com> ] On Wed, 26 Jan 2000 17:18:57 GMT, Loki wrote: >My assumptions are that the dataset will grow to no more than 25GB at this >time, with the current fields (there is a proposal to revamp the system to >add additional tables storing additional data), but for that 25GB, there >will be many many records, (the records themselves are quite small, but we >have alot of them) > >Our current setup is happy with 3GB, but as I said, it is anticipated to >grow to somewhere over 20GB, no more than 25GB This still sounds like an order of magnitude change in scale - from the GB range to the 10s of GB range. I may be somewhat biased - but DB2 has the scalability to handle the entire range, and it has a pricing structure to match. You can get small systems (single-user databases) to mid-sized (small workgroups) to enterprise-sized to clustered enterprise. If you're on a platform that has all of these options, you can simply install the larger DB2 over the smaller, and keep on workin'! (Stop/start databases may be required - reboot sometimes required on OS/2 and Windows.) As for your other requirements - ask around in c.db.ibm-db2, or check their website (www.ibm.com/db2, I think). I think it has at least 90% of them, possibly all of them. -- I do not speak for my employer. I don't even speak for myself - ask my wife. -- my email address is incorrect, please look at the X-De line in the header (De - French for FROM)