|
Which is hard to explain that random keys are slower than sequential generated. A sequence used as an index does need rebalancing the binary tree very often...?
|
|
|
|
|
Well, maybe I'm mixing things up, it was years ago that we did the migration, but I know for sure that PostgreSQL handles GUID's as Primary Keys much better than SQL Server did. SQL Server also demanded a lot more maintenance of the indexes (which we don't even have to do on PostgreSQL)
|
|
|
|
|
I don't like GUIDs as IDs in any case.
How often do you have to find something by ID and then type that huge GUID?
It also doesn't say anything about when a record was created, at least you can say record 876231 came after 876230 and before 876232, could be a useful piece of information.
So I'm not using GUIDs as internal IDs, but I can use them as external secondary IDs, like in URLs and such.
Didn't know the NEWSEQUENTIALID 
|
|
|
|
|
We don't type in GUID's, it's just to have a unique ID, if you can get away with using simple integers that will speed things up of course but can lead to other problems, e.g. when you have to merge information from other databases.
You are correct in saying that a GUID is terrible for information about when a record was created (or sorting purposes!) that's precisely the reason why they came up with NEWSEQUENTIALID to solve this.
|
|
|
|
|
|
RickZeeland wrote: Nowadays
By which you mean "since 2005". 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
The problem with GUID is "global" is limited to the machine that created the ID. This is in the definition details for GUIDs.
|
|
|
|
|
So far for "Global domination", seems to be an actual theme at the moment 
|
|
|
|
|
That depends on the type. In theory, one of the types (I forget which) includes the computer's mac address (of the primary interface) so some ms docs come with the caviot like
Each GUID generated by using NEWSEQUENTIALID is unique on that computer. GUIDs generated by using NEWSEQUENTIALID are unique across multiple computers only if the source computer has a network card."
sql server NEWSEQUENTIALID docs
|
|
|
|
|
see [^] for some interesting details on GUID/UUID.
«The mind is not a vessel to be filled but a fire to be kindled» Plutarch
|
|
|
|
|
Victory is a part of being charming! (7)
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Winning ?
"Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP
|
|
|
|
|
Some part missing I suspect ...
|
|
|
|
|
Yes I don't get that bit totally, but a winning smile could be a part of being charming I suppose.
"Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP
|
|
|
|
|
Nope!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
WIN-SOME Victory, part of. def: charming
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
And you are up tomorrow! 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I guessed the correct answer, but I was not certain of your formula:
Victory - WIN
is a part of - substring of
being - someone -> SOME
charming - definition
! make it a sentence
|
|
|
|
|
Firstly, always assume punctuation is there to confuse you ... except when it isn't ... 
My thoughts were:
Victory WIN
is a part of SOME being charming!
WINSOME
So you were pretty close!
Better luck next time - keep going, you'll get there.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
See why I did not answer…
I thought “being” aka human being -> someone was a bit of a stretch.
I thought part of CCC rules is that there is a single word for the definition and it must be the first or last word.
I would say that hyphenating being-charming to make it one word might work, but it would be pretty obvious which word was the definition. So scratch that.
|
|
|
|
|
I finally got one at first glance 
"Time flies like an arrow. Fruit flies like a banana."
|
|
|
|
|
Yay! We'll have you posting CCC's in no time! 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
|
Happy indeed!!!
"The only place where Success comes before Work is in the dictionary." Vidal Sassoon, 1928 - 2012
|
|
|
|
|
Happy birthday! and a pat on the back from me (also for the cat) 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Beer | [beer]](https://codeproject.freetls.fastly.net/script/Forums/Images/beer.gif)
![Jig | [Dance]](https://codeproject.freetls.fastly.net/script/Forums/Images/jig.gif)