Mehdi Akiki

Posts tagged "full-text search"

  • Published on

    Investigation · Part 10 of 10 · Inside a database index

    Keeping a Derived Index in Sync Outside the Database

    I killed a program 200 times while it wrote documents and their search entries in two transactions: 104 documents became invisible to search, without any error. One transaction, or triggers, gave zero. When the copy lives in another system, only an outbox and reconciliation are left.