Comparison between diiferent approaches of implemetation of matrices in a database: The serialization approach in SQLite, the read and write table from DBI approach in SQLite and the read and write table from DBI approach in PostgreSQL. One can see, that both approaches, that aren’t over PostgreSQL, suffer greatly from a big database. Meanwhile PostgreSQL isn’t affected by that. This is a close look on the connection times for the SQLite and PostgreSQL.
If the connection to the database doesn’t get opened and closed every time, the difference between a big and a small database becom smaller and the difference between PostgreSQL and SQLite also becomes smaller.