On Fri, Jan 25, 2013 at 4:21 PM, Jeff jeffpl...@yahoo.com wrote:
(Using FB 1.5)
OK, that's scary right there. Firebird 1.5 is ten years old. Newer
versions use approximately the same index structures but have lots of bugs
fixed, including several important ones in the index code.
Do
(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
On 26-1-2013 14:42, Thomas Steinmaurer wrote:
(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
On 26-1-2013 14:42, Thomas Steinmaurer wrote:
(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
Thomas,
I once run a test with insertion performance in Firebird 2.5 with a)
sequential PK values coming from a generator and b) via the built-in
function giving me a UUID.
reversed UUIDs, by putting the fixed part at the front, should perform
better in this regard than plai UUID.
I don't
I once run a test with insertion performance in Firebird 2.5 with a)
sequential PK values coming from a generator and b) via the built-in
function giving me a UUID.
reversed UUIDs, by putting the fixed part at the front, should perform
better in this regard than plai UUID.
I don't know if
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
At 10:21 a.m. 26/01/2013, Jeff wrote:
Hi all,
(Using FB 1.5)
Do inserts in FB benefit from ordered or sequential PK?
No.
Please allow me to clarify. I intend to use High/Low for table PKs.
I don't know what that might be.
With this approach, it is very possible that PKs will not be in
Jeff wrote:
I based this question on this article:
http://www.codeproject.com/Articles/388157/GUIDs-as-fast-primary-keys-under-multiple-database
I'd expand on Helen's comment ...
The article is not particularly clear on what problem is trying to be solved?
All it is doing is adding a