|Subject||Re: [firebird-support] Re: separate table or separate database|
> In my scenario, I am not searching for a particular name. My query isThe problem with separate tables is when you have to query across
> to list all names inserted in a specific week. if I split my 10
> million names based on time-range, i.e., one table per week, then I
> only need to search 1~2 tables with much smaller amount of data.
Do you have any indices on your large table? How many rows per week?
> > Now, imagine I have a phonebook with 10 million names, searching forMartijn Tonies
> > a specific name becomes slower.
> > Now, imagine I have 1 million phonebooks with 10 names each. Why does
> > this make searching for a specific name faster?
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!