Date: Thu, 20 May 1999 13:08:58 -0400 From: Dan Moschuk <dan@trinsec.com> To: Chuck Robey <chuckr@picnic.mat.net> Cc: hackers@FreeBSD.ORG Subject: Re: Database holywars? Message-ID: <19990520130858.A94463@trinsec.com> In-Reply-To: <Pine.BSF.4.10.9905201249270.69006-100000@picnic.mat.net>; from Chuck Robey on Thu, May 20, 1999 at 12:51:26PM -0400 References: <19990520125421.A94348@trinsec.com> <Pine.BSF.4.10.9905201249270.69006-100000@picnic.mat.net>
next in thread | previous in thread | raw e-mail | index | archive | help
| > I'd like to stay away from the commercial database suites (i.e. Oracle) for | > the time being, however I will eventually move to it once the database grows | > to over 100M records. In the meantime however, I'm debating heavily between | > MySQL and Berkeley DB with a multi-threaded socket frontend. | > | > Suggestions and comments? | | What's more important, flexibility to make changes, or speed? Anything | that implements sql has to be far slower, but if you make many changes, | you're going to heavily regret choosing a set of C language functions | as the base of your DB. I think a proper equilibrium between the two would be most desirable, but, if I had to choose one over the other it would definately be speed. The actual structure of the database isn't going to change much, if at all, I would imagine. Assuming it changes once a year, writing a conversion program to read in the old structure and write out the new one doesn't seem quite so horrendous. On the other hand, its a lot more annoying than a simple ALTER .. ADD statement. :-) Dan To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-hackers" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?19990520130858.A94463>