From owner-freebsd-database Fri Jul 10 05:40:12 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id FAA03074 for freebsd-database-outgoing; Fri, 10 Jul 1998 05:40:12 -0700 (PDT) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from ntserver.computronic.hu (ntserver.computronic.hu [194.149.43.67]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id FAA03058; Fri, 10 Jul 1998 05:40:06 -0700 (PDT) (envelope-from andras.tudos@computronic.hu) Received: from gericom-nt (dhcp1.computronic.hu [194.149.43.80]) by ntserver.computronic.hu (Post.Office MTA v3.1.2 release (PO205-101c) ID# 0-44403U100L100S0) with SMTP id AAA750; Fri, 10 Jul 1998 14:39:57 +0200 Message-Id: <3.0.5.32.19980710144137.00ad7930@computronic.hu> X-Sender: andras.tudos@computronic.hu X-Mailer: QUALCOMM Windows Eudora Pro Version 3.0.5 (32) Date: Fri, 10 Jul 1998 14:41:37 +0200 To: freebsd-isp@FreeBSD.ORG, freebsd-database@FreeBSD.ORG From: "Andras Tudos - Computronic, C3" Subject: Highly reliable database package Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Hi, we need recommendations of a highly reliable database package having a FreeBSD client library (preferably running on FreeBSD) , which can serve a simple database with *a lot of concurrent queries* without crashing every day. We are using Postgres at the moment, but can't stay with it any more. Even the developers acknowledge this being a problem. The application: user database of a large mail server (currently ~65000 users). Andras Tudos C3, Budapest To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Jul 10 09:52:23 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id JAA05464 for freebsd-database-outgoing; Fri, 10 Jul 1998 09:52:23 -0700 (PDT) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from java.dpcsys.com (java.dpcsys.com [206.16.184.7]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id JAA05448; Fri, 10 Jul 1998 09:52:18 -0700 (PDT) (envelope-from dan@dpcsys.com) Received: from localhost (dan@localhost) by java.dpcsys.com (8.8.7/8.8.2) with SMTP id JAA05436; Fri, 10 Jul 1998 09:53:18 -0700 (PDT) Date: Fri, 10 Jul 1998 09:53:18 -0700 (PDT) From: Dan Busarow To: "Andras Tudos - Computronic, C3" cc: freebsd-isp@FreeBSD.ORG, freebsd-database@FreeBSD.ORG Subject: Re: Highly reliable database package In-Reply-To: <3.0.5.32.19980710144137.00ad7930@computronic.hu> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Fri, 10 Jul 1998, Andras Tudos - Computronic, C3 wrote: > we need recommendations of a highly reliable database package having a > FreeBSD client library (preferably running on FreeBSD) , which can serve a > simple database with *a lot of concurrent queries* without crashing every > day. We are using Postgres at the moment, but can't stay with it any more. > Even the developers acknowledge this being a problem. We're real happy with mysql. Using it handle a bunch of database apps on client websites. Running wll over 300,000 queries a day. calafia:/usr/home/dan $ mysqladmin status Uptime: 4818806 Running threads: 2 Questions: 17519383 Reloads: 5 Open tables: 63 Dan -- Dan Busarow 949 443 4172 DPC Systems / Beach.Net dan@dpcsys.com Dana Point, California 83 09 EF 59 E0 11 89 B4 8D 09 DB FD E1 DD 0C 82 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Jul 10 14:14:43 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id OAA17257 for freebsd-database-outgoing; Fri, 10 Jul 1998 14:14:43 -0700 (PDT) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from elektra.ultra.net (elektra.ultra.net [199.232.56.13]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id OAA17250 for ; Fri, 10 Jul 1998 14:14:41 -0700 (PDT) (envelope-from syang@directhit.com) Received: from moe.dirhit.com ([10.4.18.2]) by elektra.ultra.net (8.8.8/ult.n14767) with ESMTP id RAA17058; Fri, 10 Jul 1998 17:14:24 -0400 (EDT) Received: by MOE with Internet Mail Service (5.0.1459.74) id ; Fri, 10 Jul 1998 17:12:43 -0400 Message-ID: <839A86AB6CE4D111A52200104B938D435B7F@MOE> From: Steven Yang To: "'Andras Tudos - Computronic, C3'" Cc: "'freebsd-database@freebsd.org'" Subject: RE: Highly reliable database package Date: Fri, 10 Jul 1998 17:12:41 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1459.74) Content-Type: text/plain Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Hi, my company has been evaluating both GDBM and db. Both are freely available. So how many records will you have in your database? 65,000? millions? If you have 65,000 records (1 per user), and you need to update them frequently, I'd say try GDBM. If you have more than 100,000 records, I'd say try db. The reason is that insertions and updates for GDBM are decently fast for relatively small numbers of records, but the performance degrades rapidly once you go beyond 100,000 records. db achieves consistent performance for large numbers of records, but for small numbers, GDBM happens to be faster. Here's a quick summary of pros and cons that we have discovered: GDBM: Pros - index is relatively inexpensive, definitely good for updates or appends for ~50,000 records or less. We did our tests where the size of the records were 5K, and also when they were a few bytes. Either way, the insertion speed was the same. The bottleneck appears to be its indexing ability. It is very fast for read requests. Cons - if your keys are too similar, you might get a fatal error for large numbers of records (like > 112000). If your keys are pretty different, don't worry. db: Pros - seems to scale better than GDBM if you use btrees (definitely don't do db hash tables). Insertion speed seems constant even when you have more than 100,000 records. So for large indexes, db is MUCH BETTER than GDBM. db is also really fast for read requests. Cons - insertion speed for small numbers of records is significantly slower than GDBM. /////// NOTE///////// These database packages do not use SQL. They are simply lookup tables. If you need a relational database or must use SQL for some reason, try mysql. I've never used mysql, so I actually don't know anything specific about it. > -----Original Message----- > From: Andras Tudos - Computronic, C3 > [SMTP:andras.tudos@computronic.hu] > Sent: Friday, July 10, 1998 8:42 AM > To: freebsd-isp@FreeBSD.ORG; freebsd-database@FreeBSD.ORG > Subject: Highly reliable database package > > Hi, > > we need recommendations of a highly reliable database package having a > FreeBSD client library (preferably running on FreeBSD) , which can > serve a > simple database with *a lot of concurrent queries* without crashing > every > day. We are using Postgres at the moment, but can't stay with it any > more. > Even the developers acknowledge this being a problem. > > The application: user database of a large mail server (currently > ~65000 > users). > > Andras Tudos > C3, Budapest > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-database" in the body of the message To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Jul 10 19:58:25 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id TAA15463 for freebsd-database-outgoing; Fri, 10 Jul 1998 19:58:25 -0700 (PDT) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id TAA15454 for ; Fri, 10 Jul 1998 19:58:22 -0700 (PDT) (envelope-from tom@sdf.com) Received: from tom by misery.sdf.com with smtp (Exim 1.82 #3) id 0yupL8-0000Z7-00; Fri, 10 Jul 1998 19:24:42 -0700 Date: Fri, 10 Jul 1998 19:24:41 -0700 (PDT) From: Tom To: "Andras Tudos - Computronic, C3" cc: freebsd-database@FreeBSD.ORG Subject: Re: Highly reliable database package In-Reply-To: <3.0.5.32.19980710144137.00ad7930@computronic.hu> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Fri, 10 Jul 1998, Andras Tudos - Computronic, C3 wrote: > Hi, > > we need recommendations of a highly reliable database package having a > FreeBSD client library (preferably running on FreeBSD) , which can serve a > simple database with *a lot of concurrent queries* without crashing every > day. We are using Postgres at the moment, but can't stay with it any more. > Even the developers acknowledge this being a problem. > > The application: user database of a large mail server (currently ~65000 > users). > > Andras Tudos > C3, Budapest Maybe Solid Server? See www.solidtech.com. Evaluation versions for FreeBSD are now available. Very easy to setup too. Seems quite reliable to me. Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message