Finally understood what's going on. It was a regression in the new
FlushAction [1]. Old one didn't sort updates in any way.
So two issues later (and one optimization), it should be better now.
[1] https://issues.apache.org/jira/browse/CAY-2868
On Thu, Aug 15, 2024 at 3:49 PM Hugi Thordarson wrot
Hi Hugi,
>From what I've read, UUID PKs have poor index performance and take up more
storage.
Wouldn't it be better to use an integer sequence like PostgreSQL and Oracle
support? You can generate your PKs up front and Cayenne already knows how
to deal with them.
Thanks,
mrg
On Thu, Aug 15, 202
Just ran our tests with your updates and everything works like charm.
Thanks Nikita! I owe you quite a few [beverage of choice].
Cheers,
- hugi
> On 16 Aug 2024, at 13:45, Nikita Timofeev wrote:
>
> Finally understood what's going on. It was a regression in the new
> FlushAction [1]. Old one
Hi Michael!
Sure, the UUID comment was meant as a bad joke, my world is all DB generated
integer keys.
That being said, I've wanted to try out UUID keys for a while. Sure, they're
ugly as all h*** and performance would suffer (although for the size of DBs I
usually deal with I don't think it w
If UUID PKs are really going to be a thing, we should probably add them to
Cayenne...
On Fri, Aug 16, 2024 at 9:44 AM Hugi Thordarson wrote:
> Hi Michael!
>
> Sure, the UUID comment was meant as a bad joke, my world is all DB
> generated integer keys.
>
> That being said, I've wanted to try out
