<div dir="ltr">Hi,<div><br></div><div style>Emmanuel is correct. I don't see any problems in switching id column to 64bit integer type, use perl with 64bit integers and you get 9,223,372,036,854,775,807 as max value.</div>
<div style><br></div><div style>For 32bit integer you get 2,147,483,647.</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Jun 12, 2013 at 12:43 PM, Brumm, Torsten / Kuehne + Nagel / Ham GI-ID <span dir="ltr"><<a href="mailto:torsten.brumm@kuehne-nagel.com" target="_blank">torsten.brumm@kuehne-nagel.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Correct me if i'm wrong, but the Tickets id Field is int(11), this means: 99999999999 -> 99.999.999.999 should be enough for this first time<br>
<br>
Btw, we do around 1.000.000 Tks per week and still far away from this counter ;-)<br>
<br>
torsten<br>
<br>
-----Ursprüngliche Nachricht-----<br>
Von: <a href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a> [mailto:<a href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a>] Im Auftrag von Emmanuel Lacour<br>
Gesendet: Mittwoch, 12. Juni 2013 09:33<br>
An: <a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>
Betreff: Re: [rt-users] RT MAX TICKET ID<br>
<div><div class="h5"><br>
On Tue, Jun 11, 2013 at 03:57:00PM -0400, <a href="mailto:romain.pelissier@bell.ca">romain.pelissier@bell.ca</a> wrote:<br>
> Hi,<br>
> Maybe that sound as a stupid question but can you tell me what is the MAX value for a ticket ID? Is there a end-of-the-world ticket id limit?<br>
> I have been asked for this question and pretty sure that at 100000 it will still works but can find a way to confirm this.<br>
> If anyone can tell me it will be greatly appreciated.<br>
><br>
<br>
I have instances with 300K tickets. And there is someone on this list that send a setup around 1M tickets ;)<br>
<br>
So don't worry ...yet ;)<br>
<br>
--<br>
Easter-eggs Spécialiste GNU/Linux<br>
44-46 rue de l'Ouest - 75014 Paris - France - Métro Gaité<br>
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 43 35 00 76<br>
mailto:<a href="mailto:elacour@easter-eggs.com">elacour@easter-eggs.com</a> - <a href="http://www.easter-eggs.com" target="_blank">http://www.easter-eggs.com</a><br>
<br>
<br>
--<br>
RT Training in Seattle, June 19-20: <a href="http://bestpractical.com/training" target="_blank">http://bestpractical.com/training</a><br>
<br>
</div></div>Kühne + Nagel (AG & Co.) KG, Geschäftsleitung: Hans-Georg Brinkmann (Vors.), Dirk Blesius, Reiner Heiken, Holger Ketz (Stellv.), Jan-Hendrik Köstergarten (Stellv.), Bruno Mang, Christian Marnetté, Jens Wollesen, Sitz: Bremen, Registergericht: Bremen, HRA 21928, USt-IdNr.: DE 812773878, Persönlich haftende Gesellschaft: Kühne & Nagel A.G., Sitz: Contern/Luxemburg Geschäftsführender Verwaltungsrat: Karl Gernandt<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
--<br>
RT Training in Seattle, June 19-20: <a href="http://bestpractical.com/training" target="_blank">http://bestpractical.com/training</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>Best regards, Ruslan.
</div>