How to handle very large dataset

  • Something that might slow down inserts, but could really help is to add a bit column to the table to identify the most recent row. This column needs to be updated every time, but a filtered index might give you a great performance improvement.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply