I understand. I'll try to get the number of rows reading to see how we fare.
I have spoken to my hosting service - and they confirmed that if the collocated server gets overloaded, they will alert me and that they can see no problem in migrating the site to a virtual dedicated server whenever the need arises. I guess I'll take a chance and go for it.