Subject RE: [firebird-support] One large table or many small tables?
Author Leyne, Sean
> 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