Performance Problem Selecting "double" Filed

[Davide Franscella]

Hi, I have this problem... (Note I'm at the fisrt step with MySQL)

In my table (28 fileds, 52000 records) I run a Simple query:

Select *
From table

the answer time is more 10 seconds.
But if I select only a subset of field the performance are better...

Select ID,TextField, ...
From table

I find the problem is in the double dataType, in effect when I select one double field the answer time become 1 Second +
with 2 double field become 2 second...

I work with MySQL Server 4.1.10a on Linux SUSE Personal 9.1 server (in effect is not a very fast server)

And a P4 client with Win 2000.

But I have the same problem on a Windows 2000 machine with MySQL 4.0.20d, and one P4 Client and with localhost.

My Table is myIsam, but i tryed with InnoDB.

It's possible to increase the perfomance, or is a mySQL limit?


Thanks
D@vide