Polyhedra Benchmarking

[camieac]

Benchmarks

• Run some benchmarks on Polyhedra and sqlite and see how they compare
• Access Polyhedra database using TCP/IP from another Pi and see how much slower it is compared to loopback address.

  Time

SELECT		INSERT
int		int
boolean		boolean
varchar(100)		varchar(100)

Frequency

• Maximum number of inserts in 1s
• Maximum number of selects in 1s

Also any other useful benchmarks that come to mind.

[camieac]

Preliminary finding suggest Polyhedra is much faster at inserting and a bit slower at selecting, compared to sqlite.

This issue is being extended by another week in order to collect more results and add more benchmark tests.

By the end of the next sprint we should have well presented findings.

[camieac]

It would be nice to see this done, but I guess that's too optimistic! It will certainly need to be done before the report is handed in.