3 ms·
I wasn't talking about database locks. My point was that making a database request takes a really long time relative to processing a request in the web applicat
by nawitus 11y ago
I wasn't talking about database locks. My point was that making a database request takes a really long time relative to processing a request in the web application. Therefore the web application spends most of the time doing nothing and waiting for the database request to complete.
- ianamartin 11y agoSo, write data-backed applications without calling a database? Not sure what you are getting at here. If you are talking about the raw scalability of your database, yes, you are correct. The speed with which you are able to get info from your DB will be a limiting factor. But that's a totally different point than the one I was making, which was about how to scale Python, not your database. If I understand you correctly, the time spent in retrieving stuff from your database will be a limiting factor no matter what language you are using. The DB I/O will eventually limit C# or go or node.js or whatever. I really don't see how this is relevant. But since you brought it up, you can really cut down on data access times by relying less on ORMs and getting your fingers dirty with stored procedures and building tables that make sense to SQL instead of pretending everything in your RDBMS is a class.
- nawitus 11y agoNode.js can asynchronously make multiple (i.e. hundreds) database requests without locking the instance.
- mixmastamyk 11y agoWhy do you believe four requests from python would lock a database but hundreds from js wouldn't?