Re: Efficient database design for auto-incrementing, grouped, sets of data?

[Charles Carver]

Duan Smith Wrote:
-------------------------------------------------------
> An effective, accurate, and efficient database is
> only as good as its design. And good design is
> mastered only though training and experience.
> Incorporates both merge-approach and expansion
> approach data Design provides for developing a
> centrally controlled system for issuing Ids.


You're very right! How would you go about incorporating what you've described into what I'm trying to achieve? Are you suggesting a separate system, separate from any insert statements, that manages the entity ids (e.g. issues new ideas, merges ids that need to be merged, returns the next usable id, etc..)?

I'm not sure if you've read the other thread with Peter Brawley, but I described more in depth there what it is I'm trying to achieve. I can echo it here though if it's still unclear. Also, thank you for the response.