From owner-freebsd-isp Thu Feb 4 19:17:02 1999 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id TAA14330 for freebsd-isp-outgoing; Thu, 4 Feb 1999 19:17:02 -0800 (PST) (envelope-from owner-freebsd-isp@FreeBSD.ORG) Received: from mayon.cats.edu.ph (mayon.cats.edu.ph [203.172.25.131]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id TAA14320 for ; Thu, 4 Feb 1999 19:16:55 -0800 (PST) (envelope-from dune@mayon.cats.edu.ph) Received: from localhost (dune@localhost) by mayon.cats.edu.ph (8.9.0/8.8.7) with SMTP id LAA04232; Fri, 5 Feb 1999 11:28:25 +0800 Date: Fri, 5 Feb 1999 11:28:25 +0800 (PHT) From: "Francis Percival C. Favoreal" To: Dennis cc: isp@FreeBSD.ORG Subject: Re: MySQL vs mSQL In-Reply-To: <199902042354.XAA10802@etinc.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org On Thu, 4 Feb 1999, Dennis wrote: > Does anyone know how they measure up? We've got a dbase with 2.7 million > records in mSQL and its just about on the edge of usability in a system > with 64meg of ram... > > wondering if anyone has used MySQL with this large a dbase? > I remember using MySQL to keep all the logs of my former ISP. At the end of the day, thousands of records are inserted to the MySQL database. And if i remember correctly, the size of the MySQL database containing the user dialup accounting when I left a year ago was around 8M already. And by now, it is still growing. I recommend MySQL if you're going to keep a large database and evergrowing database =) I use the same setup here in my new ISP I work in. -- riko sysad CATSNET To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message