Inserts with guids have become faster… (in SQL2005 that is)

By patrickwellink
April 28, 2006
1

Ok,

I am not a real fan of the GUID datatyoe in SQL server cause some people will create clustered indexes on them and then start to insert thousands of records, Next they will start complaining SQL isn’t fast at all.
(Wich is about the same as putting a Caravan behind a Formula 1 car and then complain it won’t do 300MPH on the straight…….)

But there is something new now in SQL 2005.

Have a read and see that insert performance has increased. -> http://www.lazydba.com/sql/1__18914.html

Since he is using NewSequetialID insert performance will be ok if it’s a clustered index…..

This post is related to the old discussion about –> GUID is not always good ( a true Read the &*%^&%^& Manual story)

Comments: 1

  1. Patrick Wellink says:

    Whelllllll….

    I guess it will corner quite bad with the basis of the caravan dangeling behind it….

    I don’t know which is heavier … caravan basis / F1 car…

    Well let’s give Top Gear a call…..

Comments are closed.

  • Recent Posts
  • Recent Comments
  • Archives
  • Categories
  • Meta