|Subject||Re: [firebird-support] Re: separate table or separate database|
> > But what makes you think your query will be faster if your tableRight, imagine if I have a phonebook with 10 names. Searching for a specific
> > data is split across more tables?
> When the table is small, the query is very fast. After it grows to
> more than 10 million records, query becomes slower and slower. Since
> I don't query all records but only a portion, I think splitting table
> into smaller ones can help improve query speed?
name is quite fast.
Now, imagine I have a phonebook with 10 million names, searching for
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!