Strange but True: speed

[gennaro]

I installed MySQL on a pentium III 1000 MHz, 256MB RAM, 60 GB HDD, etc, and a simple query thru ASP/ODBC (DNS less; the table contains 10 records only) will spend about 10 seconds.
The SAME application, same OS (Win2000prof.) running on a pentium 4- 1300 MHZ is ISTANTANEOUS! How could it be?
I've re-installed both the OS and IIS5 and ODBC too, but the result is ever the same! Is it possible that 300MHz (on processor) can change performance so dramatically?
Bye 'n' Thanks
Gen

 

[Netwrkengeer]

Sounds funky to me, I have queries going through a MySql Db on a 166 mhz compaq with 64mgs of RAM (win95), executing through Php, over the internet, From a web server (FreeBsd) on a T1 to the DB over a cable modem, and my results are instantaneous. even when I query 50 items.

The real question should be, Why am I not using Unix and Php.

 

[rycamor]

Sounds like a bug. What version of MySQL? Are you using a third-party ODBC library? (I'm not familiar with ODBC on MySQL--can it be done with Microsoft's ODBC or does it need an external MySQL-specific library?)

 

[gennaro]

The release and support libraries are the same in both applications.
On sunday I'll try to REINSTALL (again) Windows2000 on pentium 3!