| # |
Jul 2nd 2018, 13:46 |
 joshualuckers |
Parent/child and some of them have many to many. When all entities are new its "fast". When they exists and there is data modified (for all those records data is changed in this case) it takes a while.. |
| # |
Jul 2nd 2018, 13:45 |
itmpls |
are most of those from 1-2 associations? saveStrategy of replace? |
| # |
Jul 2nd 2018, 13:44 |
itmpls |
lol |
| # |
Jul 2nd 2018, 13:44 |
joshualuckers |
records with those, haha |
| # |
Jul 2nd 2018, 13:44 |
itmpls |
or records within those? |
| # |
Jul 2nd 2018, 13:44 |
itmpls |
4000 associations?? |
| # |
Jul 2nd 2018, 13:44 |
itmpls |
uh. what? |
| # |
Jul 2nd 2018, 13:43 |
johnwayne |
@lorenzo thank you, I have make another association in Model. |
| # |
Jul 2nd 2018, 13:43 |
joshualuckers |
4000, long as in 30+ minutes. All of them changed |
| # |
Jul 2nd 2018, 13:41 |
itmpls |
iirc, you don't have to specify everything/all associations if your'e not modifying some of them |
| # |
Jul 2nd 2018, 13:41 |
itmpls |
are all of them being changed? |
| # |
Jul 2nd 2018, 13:41 |
itmpls |
how many associations? |
| # |
Jul 2nd 2018, 13:41 |
itmpls |
define a 'long while' ? |
| # |
Jul 2nd 2018, 13:40 |
joshualuckers |
I'm having an entity with a lot of associations. When I save the entity it takes a long while because of ```if ($entity->getErrors()) { return false; }``` in ORM/Table.php. Is it possible to skip getErrors()? |
| # |
Jul 2nd 2018, 12:51 |
lorenzo |
if you want automatic fields selection, you can use `contain()` |
| # |
Jul 2nd 2018, 12:51 |
lorenzo |
that’s why |
| # |
Jul 2nd 2018, 12:50 |
lorenzo |
it will not select the fields for a join unless you tell it to |
| # |
Jul 2nd 2018, 12:48 |
johnwayne |
Items are related with addresses (inner join), but I need only in one case left join so I can make another relation in model with another alias (for left join) but I am wondering why this doesnt work or why RAW statement is correct and execution in cakephp is wrong |
| # |
Jul 2nd 2018, 12:47 |
johnwayne |
But it is interesting if I use ->select(columns) then it is working |
| # |
Jul 2nd 2018, 12:43 |
lorenzo |
if `Items` is associated to `Addresses` it is better if you just use `leftJoinWith` instead of a plain `join` |
| # |
Jul 2nd 2018, 12:42 |
lorenzo |
the result will be in `$item->get('Addresses')` |
| # |
Jul 2nd 2018, 12:37 |
johnwayne |
I have problem with left join query..... here is the query https://paste.ofcode.org/wPHtRrybdw5B6ERfTarW55 If I execute RAW SQL statement directly in DB (from cakephp query) I am getting left join (relevant addresses if there is address_id by items), but in cakephp as final result there is no data from Addresses (left join is always empty) |
| # |
Jul 2nd 2018, 12:30 |
josbeir |
nm '-v' does the trick |
| # |
Jul 2nd 2018, 12:30 |
josbeir |
is there an argument for phpunit to list skipped/incomplete tests? |
| # |
Jul 2nd 2018, 12:03 |
Martin` |
now I've imported 800 new stores, and page does not load anymore. not a surprise |
| # |
Jul 2nd 2018, 12:02 |
Martin` |
gets path of every store |
| # |
Jul 2nd 2018, 12:02 |
Martin` |
I've seen the old version of this page (in cakephp 1.3), but it loads the depth of every store during loading of the page :P |
| # |
Jul 2nd 2018, 12:01 |
Martin` |
hmm that is a good idea :) |
| # |
Jul 2nd 2018, 11:59 |
dereuromark |
similar to what countercache behavior does etc |
| # |
Jul 2nd 2018, 11:59 |
dereuromark |
usually when you save it as post work to be done |
| # |
Jul 2nd 2018, 11:56 |
Martin` |
I think I can manage that :P |
| # |
Jul 2nd 2018, 11:54 |
Martin` |
hmm ok, just have to do that during the rending of the view then I think? |
| # |
Jul 2nd 2018, 11:52 |
dereuromark |
you can cache the depth into the root elements |
| # |
Jul 2nd 2018, 11:48 |
Martin` |
I mixed dutch en english :P |
| # |
Jul 2nd 2018, 11:47 |
Martin` |
tree of all the supermarkets in the netherlands |
| # |
Jul 2nd 2018, 11:47 |
Martin` |
I've a database with a tree of alle supermarkkets in the netherlands. now I want to paginate this data but it is to much to load all in one. but I want to show it as a tree in view. I think the best way to get this is to order at lft. but how can I find out how deep an item is? |
| # |
Jul 2nd 2018, 11:38 |
birdy247 |
@dereuromark :slightly_smiling_face: |
| # |
Jul 2nd 2018, 11:37 |
dereuromark |
I got some shells to fix these things in Setup plugin |
| # |
Jul 2nd 2018, 11:37 |
edgaras.jan |
or even better utf8mb4 |
| # |
Jul 2nd 2018, 11:36 |
birdy247 |
now to change it.. |
| # |
Jul 2nd 2018, 11:35 |
josbeir |
all should be utf8 |