From owner-freebsd-hackers Thu May 20 10: 2:44 1999 Delivered-To: freebsd-hackers@freebsd.org Received: from november.jaded.net (november.jaded.net [209.90.128.250]) by hub.freebsd.org (Postfix) with ESMTP id 66E5D14D27 for ; Thu, 20 May 1999 10:02:36 -0700 (PDT) (envelope-from dan@november.jaded.net) Received: (from dan@localhost) by november.jaded.net (8.9.3/8.9.3+trinsec_nospam) id NAA94548; Thu, 20 May 1999 13:08:59 -0400 (EDT) Date: Thu, 20 May 1999 13:08:58 -0400 From: Dan Moschuk To: Chuck Robey Cc: hackers@FreeBSD.ORG Subject: Re: Database holywars? Message-ID: <19990520130858.A94463@trinsec.com> References: <19990520125421.A94348@trinsec.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.4i In-Reply-To: ; from Chuck Robey on Thu, May 20, 1999 at 12:51:26PM -0400 Sender: owner-freebsd-hackers@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG | > 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