> Could you have a better disk environment on the Solaris machine versus the
> win32-machine?
The Solaris machine was a little bit slower executing the query, but it runs
as a production-webserver and there is much more load on it than on my
win32-test-machine.
> query that inserted 10000 string values, but wouldn't it make a great
> difference if you made 10000 queries that each inserted only one value??
> that's more my situation and I think that's a lot slower, but I do agree
I tested it with 10.000 queries executing one after the other with
MySQL-Front, too. Result: about 20 seconds. You must notice one thing:
executing one query with a GUI like MySQL-Front means not only "executing",
but *many* other things too: desplaying the query in the history-window,
finding out, if the query returns a result and so on. These side-mechanisms
take a lot of time. If you make an application with the C-API, which
executes exactly only the query and *nothing* else, you would get much
better results.
Greetings,
Ansgar Becker
[EMAIL PROTECTED] | http://www.anse.de
AB7670-RIPE
---------------------------------------------------------------------
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
