On 10/18/2012 2:54 AM, Paul Hill wrote:
On 17 October 2012 22:10, MB Software Solutions, LLC
<[email protected]> wrote:
Will give it a shot. What a freakin PITA. Should have used integer keys
and been done with it long ago.
I think you're missing the point of GUIDs Mike.
With GUIDs it's perfectly safe for the client application to generate
the primary keys.
So you can create a record in memory and let the user edit it. You
generate the PK at this time, not save time.
You can even add child records (still in memory), all populated with
the foreign key of the master.
Saving is easy: you just write to the database.
Having said that - I don't use PKs. My databases tend to be highly
relational and the overhead of 128bit guids is substantial.
Thanks for that, Paul. As for the 128-bit part, is it really that much?
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
