MySQL Forums
Forum List  »  Performance

Performance Problem Selecting "double" Filed
Posted by: Davide Franscella
Date: April 06, 2005 08:04AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Performance Problem Selecting "double" Filed
2466
April 06, 2005 08:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.