I have a problem with a Drupal 6 site. It's hosted on shared hosting, where I can only use up to 20 database connections. It attracted more visitors than I expected. So maybe it simply became too big for a small shared hosting space. But it feels like a bug to me. here is why.
There is a view with a lot of pages (~20 000 nodes, 10 per page), two fields per node and three exposed filters. Nothing special really. It's cached, so performance-wise everything is fine (not everybody uses the exposed filters). I can edit the view, edit fields, add fields. But whenever I want to save changes in the "Basic settings" section on the view's edit page, the small blue clock stays there for several minutes and stops with an error 500 message. The site is then offline because it can't connect to the database ("Too many connections"). When I close the tab while it is trying to save my changes (pressing Cancel doesn't work either) it's the same. After a few minutes the site goes offline. And it's the same with any other view. I have a different view that only user 1 can access and it's the same there. Sometimes it works and saves the changes (sometimes after one or two minutes, someties after a few seconds). I think this is when only a few visitors are on.
It's Views 6.x-2.16 and MySQL 5.0.95. I haven't found an issue on the views module related to this. So, does this simply indicate that I should get a VPS or dedicated server for this site so I can use more database connections? I don't see why editing a view is so special and needs many connections.