Forum Post: Re: Improving The Performance Of Query

  • Thread starter Thread starter Mark Davies
  • Start date Start date
Status
Not open for further replies.
M

Mark Davies

Guest
A read on 10,000 records should still take less than one second - especially with NO-LOCK. If you are not seeing sub-second response on your read then there might be other things you want to look at. If your read is sub-second then the chances of someone else updating the same data is incredibly rare and you are getting data from a snapshot of the records when you query it at a specific time.

Continue reading...
 
Status
Not open for further replies.
Back
Top