I guess it depends more on the script you are using and what kind of resources does it require. If just html files, then I am sure shared hosting would be no problem. However, for database intensive scripts, you will probably need to go for something more powerful.