greg/mentat

[tx] Prepare and cache SQL statements for :db/add, :db/retract, etc #105

New issue

Open

opened 2020-08-06 16:54:59 +00:00 by gburd · 0 comments

gburd commented

2020-08-06 16:54:59 +00:00

(Migrated from github.com)

The set of SQL statements for adding and retracting datoms is limited. We will achieve significant performance benefits by caching the compiled statements and merely re-binding them.

This ticket tracks using the rusqlite statement cache (if it's appropriate), or implementing our own statement cache for the transactor statements. It's worth noting that the transactor will be single-connection-on-single-thread, so the cache will not need to be sophisticated.

The set of SQL statements for adding and retracting datoms is limited. We will achieve significant performance benefits by caching the compiled statements and merely re-binding them. This ticket tracks using the `rusqlite` statement cache (if it's appropriate), or implementing our own statement cache for the transactor statements. It's worth noting that the transactor will be single-connection-on-single-thread, so the cache will not need to be sophisticated.

Sign in to join this conversation.

No labels

good first issue

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: greg/mentat#105

No description provided.