Optimize overall performance - Githubissues

PedroArvela / sentido

SENse Through InDuctiOn

1 stars 0 forks source link

Optimize overall performance #11

Closed PedroArvela closed 6 years ago

PedroArvela commented 6 years ago

In gitlab by @PedroArvela on Jun 3, 2017, 16:20

The database population with values is extremely slow. There are some simple improvements which can be done to improve performance:

[x] Batch as many inserts as possible in a single transaction.
[x] Use prepared statements where possible.
[x] Use simpler primary keys for as many tables as possible.
[x] Ensure no SELECTs are executed during writes to prevent slowdowns.
[x] Reduce repeated reads to the database as much as possible.