From owner-freebsd-isp  Thu Feb  4 17:39:58 1999
Return-Path: <owner-freebsd-isp@FreeBSD.ORG>
Received: (from majordom@localhost)
          by hub.freebsd.org (8.8.8/8.8.8) id RAA29177
          for freebsd-isp-outgoing; Thu, 4 Feb 1999 17:39:58 -0800 (PST)
          (envelope-from owner-freebsd-isp@FreeBSD.ORG)
Received: from sonic.fan.net.au (sonic.fan.net.au [203.20.92.3])
          by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id RAA29152
          for <isp@FreeBSD.ORG>; Thu, 4 Feb 1999 17:39:53 -0800 (PST)
          (envelope-from bambi@Hughes.com.au)
Received: from fawn.Hughes.com.au (fawn.hughes.com.au [203.23.133.33])
	by sonic.fan.net.au (8.9.1/8.9.1) with ESMTP id LAA24564;
	Fri, 5 Feb 1999 11:39:41 +1000 (EST)
Received: from localhost (hughes@localhost)
	by fawn.Hughes.com.au (8.8.7/8.8.5) with SMTP id LAA06143;
	Fri, 5 Feb 1999 11:39:40 +1000 (EST)
X-Authentication-Warning: fawn.hughes.com.au: hughes owned process doing -bs
Date: Fri, 5 Feb 1999 11:39:40 +1000 (EST)
From: "David J. Hughes" <bambi@Hughes.com.au>
To: Dennis <dennis@etinc.com>
cc: isp@FreeBSD.ORG
Subject: Re: MySQL vs mSQL
Message-ID: <Pine.BSF.3.96.990205113154.935K-100000@fawn.hughes.com.au>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Sender: owner-freebsd-isp@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.org


> 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...

Dennis,

I'd be more than happy to talk to you about cranking out the best
performance numbers for mSQL.  I'd even be happy to load up your data set
on our test servers and work out how to tune it for your queries.  Just
drop me a line in private mail if you want some help with this. 

As an aside, the 2.0.7 release has some mod's to the AVL code that reduces
the size of your index files considerably.  As the tree's are mmap()ed,
this size reduction will help your memory utilisation and paging overhead. 
2.0.7 will be available from our web site on the 15th of Feb.


Bambi
...


   /   /            /             David J. Hughes      Bambi@Hughes.com.au
  /___/       ___  /__  ___  ___  Managing Director    Hughes Technologies
 /   / /  /  /  / /  / /__/ /__   Fax:+61 7 3302 2199  http://Hughes.com.au
/   / /__/  /__/ /  / /__  ___/   _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/
            __/


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-isp" in the body of the message