[rt-users] RT MAX TICKET ID

[Ruslan Zakirov]

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 <torsten.brumm at kuehne-nagel.com> 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: rt-users-bounces at lists.bestpractical.com [mailto:
> rt-users-bounces at lists.bestpractical.com] Im Auftrag von Emmanuel Lacour
> Gesendet: Mittwoch, 12. Juni 2013 09:33
> An: rt-users at lists.bestpractical.com
> Betreff: Re: [rt-users] RT MAX TICKET ID
>
> On Tue, Jun 11, 2013 at 03:57:00PM -0400, romain.pelissier at bell.ca 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:elacour at easter-eggs.com  -   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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130612/95829758/attachment.htm>