| Subject | Re: [firebird-support] Benefit from Sequential Insert of High/Low PK |
|---|---|
| Author | Nando Dessena |
| Post date | 2013-01-26T14:15:34Z |
Thomas,
better in this regard than plai UUID.
I don't know if the function you have used generates that kind of UUID.
I know that I once used a UDF that did that and performance was better
than with (at the time, client-generated) UUIDs.
High/Low is also good, as huge batch of inserts would inherently use
sequential IDs, but this requires a little more setup.
--
Nando Dessena
> I once run a test with insertion performance in Firebird 2.5 with a)reversed UUIDs, by putting the fixed part at the front, should perform
> sequential PK values coming from a generator and b) via the built-in
> function giving me a UUID.
better in this regard than plai UUID.
I don't know if the function you have used generates that kind of UUID.
I know that I once used a UDF that did that and performance was better
than with (at the time, client-generated) UUIDs.
High/Low is also good, as huge batch of inserts would inherently use
sequential IDs, but this requires a little more setup.
--
Nando Dessena