Speeding Up MySQL with Indexes0

MySQL is an excellent database product and even though Oracle just bought out Sun, who bought out MySQL, Oracle still promised to keep up with MySQL patches and releases. (see more here)  This is great news for all us die hard MySQL and PHP guys, we no longer have to worry about giving up our MySQL for something else (because you can have my PHP when you pry it from my cold dead fingers).  Though the question of the day is, when we get Millions of records how can we speed it up. Say for example I have a callrecord database that has a few things in it
[read more]