|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 doLet's see...
> 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)
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