All the features needed to replace the MySQL version have been coded, and uploaded to the main server now.
I'll be keeping an eye on the performance today.
Since it's optimized for O(n) it should slow down as more and more records are added ...
Should that become a big issue, I have a fairly simple way to optimize Updates for O(c). ;-)
Rebuilding the index at midnight is another operation I'll be curious about...
Will it lock for a fraction of a second?
For a second?
For seconds?