search

sebastienros / yessql

A .NET document database working on any RDBMS
MIT License
1.22k stars 198 forks source link

Deferred indexes #173

Open jersiovic opened 5 years ago

jersiovic commented 5 years ago

It would be useful for certain scenarios we can declare an index as deferred. It will be useful when we don't want/need to wait for the index creation cause it takes too long time and we don't need to be aware of when changes on index are performed.

wedge206 commented 5 years ago

+1

sebastienros commented 5 years ago

Eventual consistency. Compared to the current state which is always consistent as the indices are committed in the same transaction as the data.

To achieve that I think it would require a separate queue of SQL statements and a task that would process this queue. So the index commands would not go to the database directly. Very hard to implement as there would be many side effects.