Subject | Benefit from Sequential Insert of High/Low PK |
---|---|
Author | Jeff |
Post date | 2013-01-25T21:21:58Z |
Hi all,
(Using FB 1.5)
Do inserts in FB benefit from ordered or sequential PK?
Please allow me to clarify. I intend to use High/Low for table PKs. With this approach, it is very possible that PKs will not be in sequential order as they are inserted into the db. Will this be an issue in FB?
I based this question on this article:
http://www.codeproject.com/Articles/388157/GUIDs-as-fast-primary-keys-under-multiple-database
Thank you.
(Using FB 1.5)
Do inserts in FB benefit from ordered or sequential PK?
Please allow me to clarify. I intend to use High/Low for table PKs. With this approach, it is very possible that PKs will not be in sequential order as they are inserted into the db. Will this be an issue in FB?
I based this question on this article:
http://www.codeproject.com/Articles/388157/GUIDs-as-fast-primary-keys-under-multiple-database
Thank you.