autoNumber and Max+1 which is Best
-
Autonumber and Max+1 which is Best for long term What are their advantages and disadvantages please answer these question with solid reason Tariq Mahmood Software Engineer
-
Autonumber and Max+1 which is Best for long term What are their advantages and disadvantages please answer these question with solid reason Tariq Mahmood Software Engineer
if u need sequential ID serie , MAX+1 is the best. Because sometimes in rollbacked transactions, AutoNumber is generated but it is not used and ,in a new record, u may see number series like 1,2,3,4,6,7,8 (that means in 5th saving,something went wrong, and data wasnt saved to database but autonumber generated) if u doesnt need sequential ID serie , AutoNumber is best. Because when u insert a new row to database,First u have to read Max number, then increase that number after checking that value is null either not.Sometimes to control this value is painful
-
Autonumber and Max+1 which is Best for long term What are their advantages and disadvantages please answer these question with solid reason Tariq Mahmood Software Engineer
If you're ever going to have more than one user acces your database, then you have to use AutoNumber. Max+1 could potentially give problems if two people (or processes) inserted into the datbase at the same time.