if you had 100 years of calls, having say 4 channels per call, you could have 63,173,781,074,347 calls per day that's 63 trillion calls... i wouldn't worry too much about seeing repeat/cycle anytime soon. You are talking about having 9 quintillion records, it should be safe to say that with bigint/serial setup like that you will be fine... you're much more likely to have a database server crash than run out of indexes at that point. On Tue, Nov 4, 2014 at 11:03 AM, Joel White <joelewhite@gmail.com> wrote:
Well here is what I have done, I think that it should work. The PK is a SERIAL DataType and I went into the sequence properties and set it to CYCLED. The max value is 9223372036854775807 and will re-cycle once that number is reached.
I only added this to the channels table right now. I have not seen any issues yet.
On Mon, Nov 3, 2014 at 4:50 PM, Michael Jerris <mike@jerris.com> wrote:
I've used bigint with a default of a sequence in the past to good results. make sure to add the option to not recreate the tables so we don't mess up your fields when we change scheme and when upgrading review for schema changes and make them manually
On Monday, November 3, 2014, Joel White <joelewhite@gmail.com> wrote:
Is there another datatype that would be more suitable. I plan to have massive amounts of traffic. Would the time datatype be more suitable?
On Mon, Oct 20, 2014 at 12:26 PM, Joel White <joelewhite@gmail.com> wrote:
Thank you Chris
On Fri, Oct 17, 2014 at 2:08 PM, Chris Tunbridge <blasterjr@gmail.com> wrote:
Serial is identical to mysql's Auto Increment, so i'm going to say yes.
On Fri, Oct 17, 2014 at 9:36 AM, Joel White <joelewhite@gmail.com> wrote:
Chris and William,
Can those added PKs have a data type of SERIAL?
On Wed, Oct 15, 2014 at 11:33 PM, William King < william.king@quentustech.com> wrote:
> Yes, you can add columns to those tables with no issues. Try it > and see. > > William King > Senior Engineer > Quentus Technologies, INC > 1037 NE 65th St Suite 273 > Seattle, WA 98115 > Main: (877) 211-9337 > Office: (206) 388-4772 > Cell: (253) 686-5518william.king@quentustech.com > > On 10/8/14 9:44 AM, Joel White wrote: > > Is it feasible to add Primary Keys to all FreeSWITCH tables or > would this break some functionality? > > I am asking because I am working on a multi-master replication setup > > > > _________________________________________________________________________ > Professional FreeSWITCH Consulting Services: consulting@freeswitch.orghttp://www.freeswitchsolutions.com > > Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon.... > > FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com > > FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees... > > > > > _________________________________________________________________________ > Professional FreeSWITCH Consulting Services: > consulting@freeswitch.org > http://www.freeswitchsolutions.com > > Official FreeSWITCH Sites > http://www.freeswitch.org > http://confluence.freeswitch.org > http://www.cluecon.com > > FreeSWITCH-powered IP PBX: The CudaTel Communication Server > http://www.cudatel.com > > FreeSWITCH-users mailing list > FreeSWITCH-users@lists.freeswitch.org > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users > UNSUBSCRIBE: > http://lists.freeswitch.org/mailman/options/freeswitch-users > http://www.freeswitch.org >
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org