> why isn't sqlite able to handle full scale loads? The goal of sqlite is to be easily embeddable: that means not too much code, not too much resources used. I

> why isn't sqlite able to handle full scale loads? The goal of sqlite is to be easily embeddable: that means not too much code, not too much resources used. It serves that purpose well: it's widely used in a lot of programs where you never even thought that they could have it. https://www.sqlite.org/mostdeployed.html https://www.sqlite.org/mostdeployed.html So the goal was never to suit your "full scale loads" the way you probably define them. But I don't know what you actually understand under the "full scale loads" and once you state what you would exactly expect to achieve it can be discussed more. Until then, simply stated, there is a reason why the big server software is big and resource hungry, unlike sqlite.