Will a VPS Web Hosting company fill my needs?

After a year and a half of hosting a CGI based database site with a shared hosting company, resulting in occasional server overloads and web site shutdowns, it’s obvious that I need to change my hosting plan. My former hosting company says that the CGI scripts are causing the overloads. Would a VPS hosting plan be a good alternative for me? Does anyone know any good, reliable VPS hosting companies?

Thanks!