search

gumuxiansheng / andro

Automatically exported from code.google.com/p/andro
0 stars 0 forks source link

Enhance automation SEQUENCE #16

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
In a production environment where databases may do master-master
replication, it a good idea to prevent conflicts on auto-incremented
values. A way to manage this is to reserve a range of sequences per
replicated database (or a starting value + increment value).

I would suggest to enhance the SEQUENCE automation with the possibility of
programming this 3 values:
- Minimum value (the minimum 'Last value' of the sequence)
- Maximum value (the maximum 'Last value' of the sequence)
- Increment

As a matter of fact it would be great if any generated sequences (skey,
recnum, etc) could provision such controls.

Original issue reported on code.google.com by mobile.d...@gmail.com on 20 May 2009 at 12:26

GoogleCodeExporter commented 8 years ago

Original comment by mobile.d...@gmail.com on 20 May 2009 at 12:40