Monthly Archives: December 2022

Performance Benchmarking Various Databases

This post summarizes results of performance benchmarking some databases. For our test, we use a dataset similar to the Star Schema Benchmark and evaluate the performance on following queries: we created a dataset with 44 M line orders. All databases … Continue reading

Posted in Computers, programming, Software | Leave a comment

Measuring the OLTP Performance of AlloyDB against Postgres using sysbench

AlloyDB is a new HTAP database that Google claims to give 4x better OLTP performance than Postgres. Here, we describe a performance test to compare its performance to Postgres as I wanted to see it for myself. TL;DR: For the … Continue reading

Posted in Computers, programming, Software | Tagged , | Leave a comment

AlloyDB Test Drive

TL;DR: Background Historically two distinct database access patterns emerged – OLTP and OLAP – and databases were developed to cater to either OLTP or OLAP. OLTP databases would capture data from transactional systems (e.g., sales orders) and the data would … Continue reading

Posted in Computers, programming, Software | Tagged | Leave a comment

MySQL – 10 Performance Tips

Misc

Posted in Computers, programming, Software | Tagged | Leave a comment

Measuring performance of BigQuery vs. Clickhouse

This post summarizes results of a performance test to compare BigQuery vs. Clickhouse – two high-performance analytics databases. Later on I performed same tests on DuckDB but as we shall see it cannot compete with CH or BQ so main … Continue reading

Posted in Computers, programming, Software | Tagged , | Leave a comment

Java vs. Node.js: Performance comparison of blocking vs. non-blocking I/O

There are many online articles touting the advantages of non-blocking I/O over blocking I/O. But I wanted to see the difference for myself. So to do that, I developed an application two ways: one using Spring WebMVC + JPA which … Continue reading

Posted in Computers, programming, Software | Tagged , , , , | Leave a comment