right approach in MySQL from a performance point of view? -
07-13-2003
, 09:47 AM
What is the better approach in MySQL from a performance point of view?
I have approx 1000 stock market fond titles that I want to insert in
MySQL on daily basis and keep them in there for some years, I'll then
use the data for presentations, analysis,… the data I save is the
name, the date, the lowest, highest and last value and the volume.
The analysis will be run on all of them on daily/weekly basis.
implementation 1:
-----------------------
I create one (1) huge table with the fields date | name | lowest |
highest | last | volume
implementation 2:
-----------------------
I create one (1) huge table per year with the fields date | name |
lowest | highest | last | volume
implementation 3:
-----------------------
I create one table per name with the fields date lowest | highest |
last | volume
implementation 4:
-----------------------
I create tables with the fields date | name1 | name2 | … | name 249
i.e.:
table 1 for lowest values for titles 1 to 249
table 2 for lowest values for titles 250 to 499
table 3 for lowest values for titles 500 to 749
table 4 for lowest values for titles 750 to 1000
table 5 for highest values for titles 1 to 249
etc. |