MySql select * performance
Hi
I have a reasonably simple table defined as:
create table company_price
(
company_price_id int(11) auto_increment,
company_id int(11),
open double,
high double,
low double,
close double,
volume double,
day date,
primary key(company_price_id, company_id)
);
I've also added another index on company_id and day.
I currently have 1.26m rows in this table which doesn't seem too excessive. However if I do a simple "select * from company_price;" from either the command line or in code the query takes between 30-45 seconds. Could anyone suggest what I'm doing wrong or how I can speed this up?
Platform: Toshiba laptop (3.2Ghz P4, 512MB Ram, VS.NET 5, mysql version 4)
Thanks and kind regards in advance
Ewan.
Subject
Views
Written By
Posted
MySql select * performance
6131
December 20, 2004 02:34PM
2834
December 20, 2004 04:40PM
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.