Subject Re: [firebird-support] SELECT MAX() or Generator
Author William L. Thomson Jr.
On Thu, 2005-12-15 at 15:40 -0500, Ann W. Harrison wrote:
>
> There are two problems with this. The first is performance, which can
> be addressed by putting a descending index on NUM.

Yep, there. I might be a borderline over indexer if anything :) Rarely
ever an under.

> The second is that
> it flat doesn't work multi-user, which may or may not be important to
> you.

It's important, but not been an issue to date. I will address before it
becomes and issue.

> If you absolutely must have sequential numbers, follow Alexandre
> Benson Smith's suggestion, but be aware that any mechanism that produces
> reliably sequential numbers will serialize updates.

Ok, thank you.

--
Sincerely,
William L. Thomson Jr.
Obsidian-Studios, Inc.
http://www.obsidian-studios.com