Hi, 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.
For 32bit integer you get 2,147,483,647. On Wed, Jun 12, 2013 at 12:43 PM, Brumm, Torsten / Kuehne + Nagel / Ham GI-ID <[email protected]> wrote: > 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 > > Btw, we do around 1.000.000 Tks per week and still far away from this > counter ;-) > > torsten > > -----Ursprüngliche Nachricht----- > Von: [email protected] [mailto: > [email protected]] Im Auftrag von Emmanuel Lacour > Gesendet: Mittwoch, 12. Juni 2013 09:33 > An: [email protected] > Betreff: Re: [rt-users] RT MAX TICKET ID > > On Tue, Jun 11, 2013 at 03:57:00PM -0400, [email protected] wrote: > > Hi, > > 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? > > 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. > > If anyone can tell me it will be greatly appreciated. > > > > I have instances with 300K tickets. And there is someone on this list that > send a setup around 1M tickets ;) > > So don't worry ...yet ;) > > -- > Easter-eggs Spécialiste GNU/Linux > 44-46 rue de l'Ouest - 75014 Paris - France - Métro Gaité > Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 43 35 00 76 > mailto:[email protected] - http://www.easter-eggs.com > > > -- > RT Training in Seattle, June 19-20: http://bestpractical.com/training > > 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 > > > -- > RT Training in Seattle, June 19-20: http://bestpractical.com/training > -- Best regards, Ruslan.
-- RT Training in Seattle, June 19-20: http://bestpractical.com/training
