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>
next in thread | raw e-mail | index | archive | help
> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.3.96.990205113154.935K-100000>