Subject Re: separate table or separate database
Author Sean
In my scenario, I am not searching for a particular name. My query is
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.

--- In, "Martijn Tonies"
<m.tonies@...> wrote:
> 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?