We care now using the merge replication in SQL server, to share and input data in web and mobile device at the same time. We found that sometimes the ID run out very fast. After the a deep search, we found that some mobile devices get the range of numbers
continuously in a short time (the time interval is several minutes), which is not possible for the device to use up all of the numbers.
We have set the subscriber range be 10000 (and the threshold 50%), each time the replication allocated 2 ranges (total 20000 numbers) to the mobile device. If the situation happen, the mobile device request ranges of number from the publication for more
than 15 times, and it has wasted for 300000 numbers.
What is the possible reason and solution for this problem? If this situation happen continuous, all ID may be distributed some time and the system will have problem.
View Complete Post