Log message #4183954

# At Username Text
# Apr 19th 2019, 10:12 asdfgh basically i have a filed named "activity" in the activity_types table
# Apr 19th 2019, 10:12 asdfgh why?
# Apr 19th 2019, 10:12 asdfgh i get this error: Using $this when not in object context
# Apr 19th 2019, 10:12 asdfgh $activityType = TableLocator::get('ActivityTypes')->findByActivity('view')->first();
# Apr 19th 2019, 10:12 asdfgh hello
# Apr 19th 2019, 00:27 kanryu How do I define a Model that does not inherit Table in Cakephp 3 and use it from the Controller?
# Apr 18th 2019, 21:20 leonardo.crecente I have a question, it's more about html than cakephp. Hope you can help me. I have a website layout in mobile and desktop versions. The navigation menu layout changes a lot from mobile to desktop. Is there any problem on using a html structure for each navigation? I'd hide via css the mobile nav on desktop and vice versa
# Apr 18th 2019, 21:04 maymeow When I use 'plugin.Identity.Users' fixture it ends with error that can't find fixture
# Apr 18th 2019, 21:03 maymeow So I have identity plugin installed in vendor
# Apr 18th 2019, 20:57 admad you can
# Apr 18th 2019, 20:34 maymeow Can I use fixture from vendor plugin or I have to extend it in my tests?
# Apr 18th 2019, 17:52 devito in cake 2 is there a databaseengine for caching?
# Apr 18th 2019, 17:52 ricksaccous which is lengthy for many records*
# Apr 18th 2019, 17:52 ricksaccous which may be lengthy
# Apr 18th 2019, 17:52 ricksaccous saveMany will always expect hydrated entities in
# Apr 18th 2019, 17:51 ricksaccous raw queries always best option
# Apr 18th 2019, 17:51 pedrorocha As curiosity, if I were using the most recent version of cakephp, should I do it with saveMany() or raw queries is still my best option?
# Apr 18th 2019, 17:48 pedrorocha Inner loop memory usage run: 1 -> 2.89 MB Inner loop memory usage run: 2 -> 37.19 MB Inner loop memory usage run: 3 -> 37.61 MB Inner loop memory usage run: 4 -> 38.04 MB Total loop memory usage -> 31.85 MB Awesome! Thank you guys
# Apr 18th 2019, 17:37 pedrorocha Thank you!
# Apr 18th 2019, 17:36 ricksaccous what*
# Apr 18th 2019, 17:36 ricksaccous ....
# Apr 18th 2019, 17:36 ricksaccous i think that he linked up there is sufficient
# Apr 18th 2019, 17:35 pedrorocha Just to be sure $db = ConnectionManager::getDataSource('default'); $db->rawQuery("INSERT ...."); is what I should be using in case of many records?
# Apr 18th 2019, 17:34 ricksaccous thanks
# Apr 18th 2019, 17:33 ricksaccous interesting, i'll consider this if i run into bottlenecks
# Apr 18th 2019, 17:33 admad update or insert depending on what you need
# Apr 18th 2019, 17:33 admad use what i linked above
# Apr 18th 2019, 17:32 ricksaccous @admad speaking of i have a point where i might be patching in 400 records.... do you recommend saving that instead with raw sql if possible?
# Apr 18th 2019, 17:31 admad https://book.cakephp.org/3.0/en/orm/query-builder.html#inserting-data
# Apr 18th 2019, 17:31 ricksaccous yeah ;)
# Apr 18th 2019, 17:31 ricksaccous using the ORM to just build the raw save query
# Apr 18th 2019, 17:31 pedrorocha Unfortunately I'm using cakephp 3.1 and I'm afraid I can upgrade it in production.. Can it be done in cakephp 3.1?
# Apr 18th 2019, 17:31 ricksaccous and probably skipping to raw sql saves is faster
# Apr 18th 2019, 17:30 ricksaccous i'd just be worried about the patchEntities anyway
# Apr 18th 2019, 17:30 admad ORM methods are meant for bulk saves anyway. Use lower level db methods
# Apr 18th 2019, 17:30 ricksaccous no you'd have to do a saveMany
# Apr 18th 2019, 17:30 pedrorocha ->save() accepts my whole array of data?
# Apr 18th 2019, 17:29 ricksaccous in one query
# Apr 18th 2019, 17:29 ricksaccous @pedrorocha why not save 15k per loop pass
# Apr 18th 2019, 17:27 slackebot loop memory usage run: 10 -> 2.69 MB Inner loop memory usage run: 11 -> 2.69 MB Inner loop memory usage run: 12 -> 2.48 MB Total loop memory usage -> 2.41 MB Why is this happening? How can I free the memory used by the inner loop on each run?
# Apr 18th 2019, 17:27 slackebot I comment the `->save()` line, it looks like this (as it should be): Inner loop memory usage run: 1 -> 2.66 MB Inner loop memory usage run: 2 -> 2.68 MB Inner loop memory usage run: 3 -> 2.69 MB Inner loop memory usage run: 4 -> 2.69 MB Inner loop memory usage run: 5 -> 2.69 MB Inner loop memory usage run: 6 -> 2.69 MB Inner loop memory usage run: 7 -> 2.69 MB Inner loop memory usage run: 8 -> 2.69 MB Inner loop memory usage run: 9 -> 2.69 MB Inner