Subject | Re: [firebird-support] SELECT MAX() or Generator |
---|---|
Author | William L. Thomson Jr. |
Post date | 2005-12-15T21:27:33Z |
On Thu, 2005-12-15 at 15:40 -0500, Ann W. Harrison wrote:
ever an under.
becomes and issue.
--
Sincerely,
William L. Thomson Jr.
Obsidian-Studios, Inc.
http://www.obsidian-studios.com
>Yep, there. I might be a borderline over indexer if anything :) Rarely
> There are two problems with this. The first is performance, which can
> be addressed by putting a descending index on NUM.
ever an under.
> The second is thatIt's important, but not been an issue to date. I will address before it
> it flat doesn't work multi-user, which may or may not be important to
> you.
becomes and issue.
> If you absolutely must have sequential numbers, follow AlexandreOk, thank you.
> Benson Smith's suggestion, but be aware that any mechanism that produces
> reliably sequential numbers will serialize updates.
--
Sincerely,
William L. Thomson Jr.
Obsidian-Studios, Inc.
http://www.obsidian-studios.com