Re: Single thread creation queue?
Re: Single thread creation queue?
- Subject: Re: Single thread creation queue?
- From: Samuel Pelletier via Webobjects-dev <email@hidden>
- Date: Mon, 22 Nov 2021 08:59:19 -0500
Hi Jesse,
Your question may have multiple answers, can you describe the contexts and
duplicate sources you fear ?
Is the primary key generated by the WO app or it is external (like a GUID) ?
Do you have a secondary identifier that should be unique ?
Anyway, you should add constraint in to the database if uniqueness is required
(this apply to all frameworks in all language)
If you use EOF primary key generation, you should not have problems with
duplicate keys. If you require high throughput, using UUID primary key or
implementing a custom generator will help by saving round trips to the database
server. If you insert in batch, it will be also faster than individual inserts.
Regards,
Samuel
> Le 22 nov. 2021 à 08:34, Jesse Tayler via Webobjects-dev
> <email@hidden> a écrit :
>
> I asked on slack but I figured I’d ping the list
>
> Who has a good way to ensure a serial EO creation queue when the system could
> be hit really fast and you must avoid duplicate entries?
>
> I’m a bit surprised I don’t recall EOF style solutions for such things and
> maybe the Amazon RDS database has a shared connection pattern the apps can
> use, I didn’t see anything so I figure this is application level stuff.
>
> Thoughts? Suggestions?
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden