I'm looking to get advice on how best to manage large databases.
I have a database I'm running with two tables over 1.5 million entries. Its made queries slow (I think mostly because its a shared server), but I wanna learn what I can/should do to make large tables more efficient. What are the most important rules? Should I be using MyISAM or InnoDB (MyISAM, right?)? I've created proper keys. Both tables only have 3 columns, but still...
So, what advice?