Hi Sean

Thanks for the input!

I will stick with the few table setup.

First of all I need to get the data prepared and into Firebird :-)

"What types of analysis are you looking to do?

That is the more important questoin"

Is this in regards to how the data should be stored?

/Jesper Kiaer

But the analysis will be Nonlinear Time Series Analysis,



-----firebird-support@yahoogroups.com wrote: -----

To: "firebird-support@yahoogroups.com" <firebird-support@yahoogroups.com>
From: "Leyne, Sean" <Sean@...>
Sent by: firebird-support@yahoogroups.com
Date: 17/09/2009 23:14
Subject: RE: [firebird-support] One large table or many small tables?





 

> I need to put a lot end-of-day stock quotes in a Firebird database to do

> some analyzing on.

>

> What is best (for performance)

:

>

> One very large table with all the data from perhaps 10.000 stocks and 5

> years of data.

>

> OR perhaps small tables, one for each stock (10.000)

Let's see...


10,000 for 5 Years = 10,000 x 5 x 365 = 18,250,000


That's not a lot of rows -- easily fits into a single table


What types of analysis are you looking to do?


That is the more important questoin


Sean





























[Non-text portions of this message have been removed]