/explore
|
You are here 
|
yoshinorimatsunobu.blogspot.com | ||
| | | | |
dincosman.com
The performance issue with an SQL query was resolved by using the /*+ PARALLEL(2) */ hint, reducing execution time from 180-200 seconds to milliseconds. The decision to perform a direct read from disk to memory instead of reading blocks from disk was made by the database engine and is controlled by the hidden "_serial_direct_read" parameter.... |
|
| | | | | ||
| | | | |
smalldatum.blogspot.com
In 2020 I published benchmark results to understand the impact of DBMS tuning options for the insert benchmark with MySQL and Postgres ( her... |
|
| | | | | ||
| | | | |
mccue.dev
[AI summary] The post advises choosing PostgreSQL as the default database for web applications due to its reliability, scalability, and better support compared to alternatives like SQLite, DynamoDB, MongoDB, and others, while cautioning against newer or experimental databases and proprietary solutions due to risks and lock-in. |
|
| | | | | ||
| | | | |
blog.panoply.io
In this article we go over the differences between SQL and NoSQL, the critical components of a database, and when to use either of these two options. |
|
| | | |||
