Launch HN: Drifting in Space (YC W22) – A server process for every user
Looks like a cool project, but I am not sure I understand the need for one process per user.<p>Some questions:<p>- Why do you need one process per user? For low latency, would you just need to make sure you have idle CPU to serve their request, even if that CPU time is multiplexed onto an event loop (one event loop serves many users)?<p>- Wouldn&#x27;t this &quot;event loop&quot; actually be more efficient that one user&#x2F;process, as there would be less context switching cost from the OS?<p>- Can I just keep a map of (connection, thread_id) on my server, and spawn one thread per user on my own server?<p>- Could I just load up my server with many cores, and give each user a SQLite database which runs each query in its own thread?<p>- This way a multi GB database would not be loaded into RAM, the query would filter it down to a result set.