Hi,
I have a database and I am expecting a lot of data to come in. I was thinking to split up the database to multiple tables i.e. if the surname of a person starts with aa to ab i put it in table a0, if ac to ad i put it in table a1. Will this make my querying faster or is it better to put it in a large table? Or if ever are there any other ways to make my database more efficient. I am also expecting high traffic in my web site so can you suggest some techniques to ease the load on the database server?