DevForce Community Forum : Inefficient NextID Allocation http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Inefficient NextID Allocation Mon, 13 Apr 2026 09:03:47 -700 Mon, 27 Aug 2007 18:01:16 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=384 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Inefficient NextID Allocation : Thanks - I knew this must have... http://www.ideablade.com/forum/forum_posts.asp?TID=384&PID=989#989 Author: MichaelP
Subject: 384
Posted: 27-Aug-2007 at 6:01pm

Thanks - I knew this must have been addressed already as it seemed like a major potential problem that is very easily avoided.
 
I would hate to think what kind of mess a database would be in if you didn't discover this issue until after the Id number range had been used up over multiple tables.
]]> Mon, 27 Aug 2007 18:01:16 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=384&PID=989#989 Inefficient NextID Allocation : There is another implementation... http://www.ideablade.com/forum/forum_posts.asp?TID=384&PID=982#982 Author: davidklitzke
Subject: 384
Posted: 27-Aug-2007 at 7:51am

There is another implementation that we have made available to developers that addresses your objection.  It's called the PooledNumericIdGenerator, and it can be found in Program Files\IdeaBlade DevForce\Sample Code\CSharp(or VB).
 
The PooledNumericIdGenerator allows you to have an entry in the NextId table for each table that you want to have its own pool of unique ids.  For more details read the comments in the source code.
]]> Mon, 27 Aug 2007 07:51:55 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=384&PID=982#982 Inefficient NextID Allocation : MichaelP, you can use PooledNumericIdGenerator... http://www.ideablade.com/forum/forum_posts.asp?TID=384&PID=981#981 Author: vkh75
Subject: 384
Posted: 27-Aug-2007 at 2:14am

MichaelP, you can use PooledNumericIdGenerator class that comes with DevForce.

Edited by vkh75 - 27-Aug-2007 at 2:17am]]> Mon, 27 Aug 2007 02:14:13 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=384&PID=981#981 Inefficient NextID Allocation : You have pointed out a very good... http://www.ideablade.com/forum/forum_posts.asp?TID=384&PID=980#980 Author: owais,zahid
Subject: 384
Posted: 27-Aug-2007 at 1:49am

You have pointed out a very good issue, this will definitly create problems. Well, the solution is simple.

1) Add the Table Name entry in NextId table and fill the NextId column with 1 (or any other value you want).
 
2) Now, modify the NumericIdGenerator class "AllocateMoreIds" function by changing the sqlselect string to add the name of your table.
 
I think this will work. I havn't tested it.
]]> Mon, 27 Aug 2007 01:49:40 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=384&PID=980#980 Inefficient NextID Allocation : The NumericIdGenerator class (version... http://www.ideablade.com/forum/forum_posts.asp?TID=384&PID=979#979 Author: MichaelP
Subject: 384
Posted: 26-Aug-2007 at 10:11pm

The NumericIdGenerator class (version from Cabana) just uses the SQL statement:
   Select NextId from NextId where Name='GLOBAL'
 
This seems like Ids are allocated globally rather than being specific for each table. This means every Id is unique and won't be used as an Id in any other table. Does this seem inefficient to anyone? This limits the total number of records of all tables to the number limit of that field.
 
I planned to use SQL Server SmallInt for some Id fields to save space, but this would then severely limit my database total number of database records in all tables to only a maximum of 32767 rows, i.e. if one table had 32700 records in it, then all the other tables could only have a combined total of 67 rows.
 
Does anyone have a smarter version of this class that allows Ids to be allocated by tablename to get around this?
]]> Sun, 26 Aug 2007 22:11:29 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=384&PID=979#979