I don't know if I would go as far to say it is senseless and inefficient to do that. It all depends on what you are trying to do and what you need it for. I am one who likes things in order and where they belong. To have...say...321 users but have a user with a userid of 415 doesn't make a whole lot of sense to me. Not to mention, the avaerage user is going to be confused themselves about it. But, like you said, if it ain't broke, it don't need fixin'. It's just personal preference, I guess.
Quote:
Originally posted by KuraFire
it could be done, but it's totally senseless and inefficient to do so.
There is no problem with gaps in user id columns, unless you intend to use certain files which include the user id and would thus have to rename files to match the gaps - but that would be quite a senseless system for users.
So why bother, then? If there's no problem, really, whatsoever, why change the very much winning formula? 
And yeah - my Quote hack works exactly the same. Quotes and Users are basically the same except that they hold different information and quotes hold far LESS information a record
|