-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160
> Always open for suggestions Well, in the spirit of the independent part of "database independent interface for Perl", you could point your scripts to a different database that has auto-cycling sequences (such as Postgres). Once set up, it will never need to be tweaked (unless you stop deleting entirely for the approximate size of what you set the sequence to). I can't think of a way to do the equivalent in mysql without having to periodically check on something, but switching to a bigint will buy you a *lot* of time (e.g. more than you'd ever need), at the cost of having ever-increasing identification numbers and slightly more storage. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200711121540 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFHOLv+vJuQZxSWSsgRA8MPAKDBHJ9on6YeVqLyBw310M2M8vaFEwCg40yB QmjApOVBDbjpfyIoZ/N6Oik= =QInM -----END PGP SIGNATURE-----
