> > But what makes you think your query will be faster if your table
> > 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?

Right, imagine if I have a phonebook with 10 names. Searching for a specific
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?



Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com