Stephane Savage wrote:
Hi,
I'm quite new to mysql and I have a question regarding the server
configuration files. I have a server with 2 go of memory and I would
like to know the reason why when I run a query (select * from Mytable)
that returns 400k rows the my-medium configuration always runs the query
in 30 sec and the my-huge configuration runs it in about 35 to 50 sec
its never the same. Doesn't the my-huge suppose to be more efficient
and faster when you have the memory to handle it? Or will I only see a
difference running a test with multiple concurrent queries?
Thanks in advance!
Stephane
You may be starving the operating system disk cache.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]