On Thu, 2004-02-12 at 11:47, Keith C. Ivey wrote:
> Craig Jackson <[EMAIL PROTECTED]> wrote:
>
> > I have a very large web app that uses timestamp for unique IDs.
> > Everything was rolling fine until we started getting many users per
> > second, causing some of the unique IDs to not be unique -- users were
> > being assigned the same timestamp. Since the web app is so large we
> > don't want to change the method of assigning IDs as it would create a
> > major project.
>
> I don't understand. If you're getting many users per second, and
> your timestamps have 1-second resolution, how could you possibly
> solve the problem without changing the method of assigning IDs?
> Are the "many users per second" periods just short bursts, and you're
> really only getting several hundred users per day? If so, I guess
> you could keep waiting a second and trying the insert again, but that
> could lead to indefinite delays if traffic gets high. I think you've
> got to bite the bullet and change the unique ID to something that's
> actually unique -- even an AUTO_INCREMENT would work.
Thanks for the speedy reply and I have already recommended
auto_increment for the solution. We do need that quick fix until the
problem is fixed. How would I go about making Mysql wait one second
between inserts. We only get about 1000 hits per day, but they tend to
be concentrated in short time intervals.
>
> --
> Keith C. Ivey <[EMAIL PROTECTED]>
> Tobacco Documents Online
> http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]