Date: Sat, 12 Aug 2000 11:41:54 +0200 From: Siegbert Baude <siegbert.baude@gmx.de> To: Andrew Gould <AndrewGould@shannonhealth.org>, "freebsd-questions@freebsd.org" <freebsd-questions@freebsd.org> Subject: Re: Technical Comparasin 'tween FreeBSD and Linux Message-ID: <39951BE2.249C6D65@gmx.de> References: <206499C84775D3119A000000F879310E011276CA@ISTECH4>
next in thread | previous in thread | raw e-mail | index | archive | help
Hello Andrew, > The test: > I have a MySQL table with approximately 1.9 million rows. I did fresh > installs of both Slackware 7.1 and FreeBSD 4.0. Hardware specs include an > Athlon 700 Mhz chip; 384Mb RAM; one 20 Mb, 5200 rpm, ATA 66 IDE hard drive > and one 15 Mb, 7200 rpm, ATA 66 IDE hard drive. The operating systems were > loaded onto the 20Mb harddrive. Two copies of the MySQL data table were > created on the 15 Mb harddrive -- one in a ufs partition and one in an ext2 > partition. From within each OS, using the MySQL client, I submitted the > following query: 'select count(hospname) as cases from hc1998;'. > > The results: > Slackware completed the query in 63 seconds (rounded down). > FreeBSD completed the query in 49 seconds (rounded up). > (63 - 49) / 63 = 22.22% difference > > My test indicates that, in this instance, FreeBSD 4.0 is faster than > Slackware 7.1. > > My questions to the database and OS experts on this list are: Can I expect > this result to be fairly representative of general performance differences: > 1) when running various SQL queries? > 2) when running any large process? Think about the different transfer rates on the same HD, changing from inner to outer areas. To be fair, you should redo the test, with the slices (partitions) changed between the two OS. Just my 0.02 (heck, where is the EURO-Symbol? O.k. 0.04 DM then :-) ) Ciao Siegbert To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?39951BE2.249C6D65>