trying to setup an optimized system to comparison test MS SQL Server
and mySQL. Database has a single 350M table with about a dozen columns.
Initial comparison between the two engines is being done w/o index help.
OS is WinNT, hardware is 1ghz processor and single hd with 512M RAM.
We just happend to have two new workstations available to setup for
the comparison side by side so it's not a monster box.
Reading through doc they suggest upping record_buffer for 512M system
from default of 128K to 1M. I found, with repeated testing, that times
go up in this case, for a simple scan query of the table
(select count(*) where blat like '1';). In other words, increasing
record_buffer
hurts performance. Similarly, dropping record_buffer down to 64K
improves performance. Range is:
64K, 7.6 seconds
128K, 8.2 seconds
4M, 10.+ seconds
anyone know why observed data is running counter to doc?
thanks,
Heitzso
Information Technology Branch
Centers for Disease Control and Prevention
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
