Log message #4179438

# At Username Text
# Mar 12th 2019, 17:57 dereuromark Anyone find this interesting? https://github.com/FriendsOfCake/search/pull/248
# Mar 12th 2019, 15:59 yoniabad Hello, I have a query composed of three tables joined with the function union (). I have problems with searches, will there be any way to optimize this query? Thank you.
# Mar 12th 2019, 15:32 dereuromark I think so, those are like 1-2 years old in that repo^^
# Mar 12th 2019, 15:32 jeremyharris cake only recently supported binary uuids though, yeah?
# Mar 12th 2019, 15:32 dereuromark at least when joining or paginating that killed our apps.
# Mar 12th 2019, 15:31 dereuromark some time ago I tried the binary(16) uuids as they are almost as performant as aiid ( https://github.com/dereuromark/cakephp-shim/tree/master/src/Database/Type ), char36 UUID are bad for performance
# Mar 12th 2019, 15:30 half2me just by reading CHAR(36) :)
# Mar 12th 2019, 15:30 half2me makes it more clear what you are trying to do for someone who might not know exactly what you are trying to do there
# Mar 12th 2019, 15:30 jeremyharris yeah abstract types are nice
# Mar 12th 2019, 15:30 half2me I prefer to use those types instead of just putting char(36)
# Mar 12th 2019, 15:29 half2me np, good to know there is a uuid type for migrations :slightly_smiling_face:
# Mar 12th 2019, 15:29 jeremyharris yep np, sorry about the mixup :)
# Mar 12th 2019, 15:29 jeremyharris I agree
# Mar 12th 2019, 15:29 half2me thanks for the help :slightly_smiling_face:
# Mar 12th 2019, 15:29 half2me its a simple behavior, but it would make the code cleaner
# Mar 12th 2019, 15:29 half2me yeah I think I'll do that
# Mar 12th 2019, 15:29 jeremyharris yeah you can make your own behavior rather quickly to keep it clean like that :+1:
# Mar 12th 2019, 15:28 half2me just thought it might be cleaner if I could use a behavior
# Mar 12th 2019, 15:28 jeremyharris ok no the generation is done outside of the type class (using the type class newId method)
# Mar 12th 2019, 15:28 half2me and just put it in the beforeSave
# Mar 12th 2019, 15:27 jeremyharris lemme check the type class
# Mar 12th 2019, 15:27 half2me i mean I could always use the Text::uuid()
# Mar 12th 2019, 15:27 jeremyharris nah not that I know of. there might be on FOC awesome list
# Mar 12th 2019, 15:27 half2me there were functions for generating, renewing etc.
# Mar 12th 2019, 15:27 half2me and I saw in the database type
# Mar 12th 2019, 15:27 half2me because I would need to regenerate those values sometimes
# Mar 12th 2019, 15:27 jeremyharris but char(36) is still what you want
# Mar 12th 2019, 15:27 half2me just wondering if there is a behavior for that
# Mar 12th 2019, 15:27 half2me no problem, yeah I thought I would need to
# Mar 12th 2019, 15:26 jeremyharris sorry I misunderstood
# Mar 12th 2019, 15:26 half2me I mean it doesn't cause any problems if we always stamp it
# Mar 12th 2019, 15:26 jeremyharris then if it’s just a field like that you will have to populate it yourself
# Mar 12th 2019, 15:26 half2me but only sometimes stamped
# Mar 12th 2019, 15:26 jeremyharris ooooh
# Mar 12th 2019, 15:26 half2me its just an identifier stamped on an entity
# Mar 12th 2019, 15:26 half2me none
# Mar 12th 2019, 15:26 jeremyharris is this for a FK or a PK?
# Mar 12th 2019, 15:26 half2me Seems to me like it shouldn't by default
# Mar 12th 2019, 15:26 half2me would the default behavior stamp anyway?
# Mar 12th 2019, 15:25 half2me if its allowed to be null though
# Mar 12th 2019, 15:25 half2me but still no stamping :)