![]() ![]() ![]() ![]() The code I'm using: public async Task mark( int id)įoo foo = await _(m => m. So why is there such a large discrepancy here?ĮDIT: I've already read this github issue, which says that all requests will be handled serially, so I/O blocking could be the playing factor, but I really can't see SQlite taking so much time for such a simple operation. To learn more, read our detailed Open Source Databases Report (Updated: July 2023). Find out what your peers are saying about PostgreSQL, Oracle, MariaDB and others in Open Source Databases. Like SQLite, it is coded in C and uses SQL as its query language to operate. July 2023 Executive Summary We performed a comparison between PostgreSQL and SQLite based on real PeerSpot user reviews. So I tried migrating to postgres and (shockingly), it can do the same amount of work in around 40-200 ms for each query.ĪFAIK, SQlite is supposed to be faster, since the data store is really small anyway (~100kb). It is a free, open-sourced, object relational database. SQLite, being an embedded database, is designed for simplicity and ease of use. If I use SQlite, for some reason, all queries return at the same time about 1000ms (!) after the calls. When it comes to functionality, both SQLite and PostgreSQL offer a broad set of features, but they excel in different areas due to their distinct design philosophies. The function itself is a simple update, where it flips the value of a record from 0 to 1 and back again and saves changes.ĭuring course of normal operation, the page may make about 10 queries at once. In my ASP.NET Core 2.0 RESTful API which uses entity framework core, I have a function to which repeated calls are made, with several at once. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |