Thanks

On May 3, 2017 1:01 AM, "Ash N" <742000@gmail.com> wrote:
John,

Thank you so much= for responding.=C2=A0 Appreciate the link to ppt.=C2=A0 Something I could = not find. but read about snowflake =C2=A0
=C2=A0=C2=A0I was looki= ng for guidance on the sequence numbers vs UUID approach.

Could I use sequence numbers ? =C2=A0are the gaps in the sequence n= umbers ever back filled?
There is not much documentation on how i= t works.=C2=A0 If some one explains, I will be more happy to update the doc= umentation.

thanks again,
-ash

=
On Wed, May 3, 2017 at 12:51 AM, John Leach <jl= each4@gmail.com> wrote:
Ash,

I built one a whil= e back based on twitter=E2=80=99s snowflake algorithm.

=

We used it as the primary key for the tab= le when in essence there was not a primary key (just needed uniqueness).

Good luck.

Regards,
John Leach

On May 2, 2017, at 6:46 PM, Ash N <742000@gmail.com>= wrote:

Hello,

Distri= buted web application.=C2=A0 Millions of users connecting to the site.
<= div>
we are receiving about 150,000 events/ sec through Kines= is Stream.
We need to store these events in a phoenix table ident= ified by an ID the primary for the table.

what is = the best way to accomplish this?

Option 1
I played with sequences and they seem to work well.=C2=A0 Although with l= ot of gaps.
will the gaps be filled at all? =C2=A0if not we will = run out of IDs pretty soon.

Option 2
UUI= Ds.

What is the best way to generate UUID's lo= cal or network?

How are folks typically handling t= his situation?

which route is recommended Sequence= s or UUIDs?

thanks,
-ash

<= /div>

--94eb2c0a6f26fda496054ec1a8b4--