Wait, why can't you add a new column to a table in MySQL or SQL Server? Putting aside the RDMS arguments, (*apart from familiarity*) why wouldn't you use something like MongoDB or CouchDB, which are accessible from more programming environments, over U2? They offer the same schema flexibility and disk space benefits you cite with U2 and so much more.
MongoDB, for instance, has built-in mechanisms for auto-sharding, replication, REST API, full-text index, and I can go on and on. And it's FREE! :-) I can't speak to performance, but I'd love to benchmark MongoDB versus U2. Maybe I will. I know I sound like a MongoDB fanboy, but I think it's a straight-up U2 killer. I challenge anyone to find an area where U2 beats it. -Rob On Wed, Jul 13, 2011 at 10:59 AM, Jeff Schasny <jscha...@gmail.com> wrote: > It scales well. I benchmarked 20K concurrent users for a wholesale > distribution application on a single (HP Superdome) server and that was 10 > years ago. > > The database structure can be painlessly modified which makes it much > easier for new applications development. Need a new field, slap it on the > end of the table and go on with your day, try that with your favorite > relational environment. > > Not so important today as it once was when disk was more expensive,but it > uses significantly less disk space than a relational database storing the > equivalent data. This also contributes to needing significantly less overall > computing power to support X number of users for a given application due to > more efficient IO, i.e. less disk reads required. > > You can use SQL, but you don't have to. This, above all, is the MY most > significant reason to use U2. > > Holt, Jake wrote: > >> I'm not sure being cheaper than Oracle can really be touted as an >> advantage, there aren't many things out there that are more expensive than >> oracle =D. And all of those things you just mentioned are also true of many >> FREE databases, so again, why pick U2? >> >> -----Original Message----- >> From: >> u2-users-bounces@listserver.**u2ug.org<u2-users-boun...@listserver.u2ug.org>[mailto: >> u2-users-bounces@**listserver.u2ug.org<u2-users-boun...@listserver.u2ug.org>] >> On Behalf Of Israel, John R. >> Sent: Wednesday, July 13, 2011 9:31 AM >> To: 'U2 Users List' >> Subject: Re: [U2] Interesting Article >> >> You may have answered your own question. Why do YOU like it? >> >> It is easy to develop, quick to code, fairly robust query language, and a >> lot cheaper than the BIG databases (Oracle, DB2, etc). >> >> >> John Israel >> Senior Programmer/Analyst >> Dayton Superior Corporation >> 1125 Byers Road >> Miamisburg, OH 45342 >> >> >> -----Original Message----- >> From: >> u2-users-bounces@listserver.**u2ug.org<u2-users-boun...@listserver.u2ug.org>[mailto: >> u2-users-bounces@**listserver.u2ug.org<u2-users-boun...@listserver.u2ug.org>] >> On Behalf Of Holt, Jake >> Sent: Wednesday, July 13, 2011 10:26 AM >> To: U2 Users List >> Subject: Re: [U2] Interesting Article >> >> I have come to like U2 over the past few years but an honest question: >> >> Why would anyone ever pick U2 beyond familiarity and personal preference? >> Can anyone think of any situation that another (and in a lot of cases a >> *far* cheaper) database isn't a better fit? >> >> Maybe if U2 had it's own niche like MySQL has with web hosting, there >> would be a market Rocket could focus on ? >> ______________________________**_________________ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/**mailman/listinfo/u2-users<http://listserver.u2ug.org/mailman/listinfo/u2-users> >> >> ______________________________**_________________ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/**mailman/listinfo/u2-users<http://listserver.u2ug.org/mailman/listinfo/u2-users> >> ______________________________**_________________ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/**mailman/listinfo/u2-users<http://listserver.u2ug.org/mailman/listinfo/u2-users> >> >> >> > > -- > ------------------------------**------------------------------** > ------------ > Jeff Schasny - Denver, Co, USA > jschasny at gmail dot com > ------------------------------**------------------------------** > ------------ > ______________________________**_________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/**mailman/listinfo/u2-users<http://listserver.u2ug.org/mailman/listinfo/u2-users> > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
