On Fri, Jan 25, 2013 at 4:21 PM, Jeff 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 inserts in FB bene
>> 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
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 k
> 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 th
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 i
> (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?
>
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 'timest
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
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 b