sqlmatrix

View the Project on GitHub

How different approaches for matrices in databases fare in dependency of the databasesize

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. barplot1 barplot2 One can see, that both approaches, that aren’t over PostgreSQL, suffer greatly from a big database. Meanwhile PostgreSQL barplot3 isn’t affected by that. barplot4 This is a close look on the connection times for the SQLite and PostgreSQL.

barplot5 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.