What technology could be used for one application to serve many simultaneous users on a small resource-constrained host (eg: Rasbperry Pi or similar)?
That is, it doesn't need a general purpose web server like Apache, as it would only need to support one application and a couple of active web pages, but many connections.
I understand Apache/PHP/MySQL on bigger servers, but those would seem to require too much resources to support many simultaneous (order of 100, say) connections on a small host - with every connection redundantly loading in its own copy of the same interpreted code.
I'm thinking, for example, to skip the general purpose webs server and have one memory resident compiled C++ program which services many concurrent HTTP connections - light weight and fast. The application would be fairly simple. Or perhaps an add-on or module for a lightweight web server. Or maybe something like node.js, if that was very resource efficient and easy to scale even on a small host. I don't even know the terminology or keywords for the style of programming I'm looking for, hence my question.
I tried StackOverflow, which suggested Raspberry Pi exchange, where this exchange was suggested. Any tips or clues?