From owner-freebsd-questions Wed Dec 6 23:36:31 2000 From owner-freebsd-questions@FreeBSD.ORG Wed Dec 6 23:36:27 2000 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from saturn.futuredesigns.net (unknown [216.91.66.1]) by hub.freebsd.org (Postfix) with SMTP id 3CB0037B404 for ; Wed, 6 Dec 2000 23:36:27 -0800 (PST) Received: (qmail 12099 invoked from network); 7 Dec 2000 07:36:25 -0000 Received: from sun.futuredesigns.net (HELO SUN.fdhosting.com) (216.91.66.69) by 216.91.66.2 with SMTP; 7 Dec 2000 07:36:25 -0000 Message-Id: <4.3.2.7.2.20001207023235.00ba6978@mail.futuredesigns.net> X-Sender: sturdee@mail.futuredesigns.net X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Thu, 07 Dec 2000 02:37:09 -0500 To: Mike Meyer From: Mike Subject: Re: OT: gdbm Cc: questions@freebsd.org In-Reply-To: <14894.15863.860076.585478@guru.mired.org> References: <122557536@toto.iv> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Using MySQL was my original plan, till I started reading more. It would have done everything I needed perfectly. But with the amount of concurrent accesses, I am worried that it would become the bottleneck in my program. I'm not storing a lot of data.. Reason I've been trying for GDBM as opposed to text files, is I've heard the programs run faster when the data is in binary format... At 07:24 AM 12/6/2000 -0600, Mike Meyer wrote: >Mike types: > > Quick off topic question: > > Would it be better/faster to pull configuration for a C or PHP cgi from a > > text file, or GDBM db? The program will be accessed over 200,000/day, so > > speed and reliability is a concern. > >If speed and reliability are a real concern, I wouldn't use either one >of those; I'd put it in an SQL db. On the other hand, this may not be >appropriate for what you're doing. > >The two methods have different speed tradeoffs, so it's hard to say >even if I had an accurate description of the problem. On the other >hand, measuring it yourself shouldn't be hard. > >As for reliability - assuming you're putting preparsed data in the >GDBM db, then not having to worry about errors during the parse makes >that a bit easier. But that's just a minor benefit. > > -- >Mike Meyer http://www.mired.org/home/mwm/ >Independent WWW/Unix/FreeBSD consultant, email for more information. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message