Log message #4193186

# At Username Text
# Jul 15th 2019, 15:12 lubos and output is one CSV file which would be OK I can append to the CSV, but neeed sort them first
# Jul 15th 2019, 15:12 lubos well I can chunk them, but i need `sortBy('created')` for all items, then chunk does not work well
# Jul 15th 2019, 15:11 ricksaccous like @kaliel is suggesting
# Jul 15th 2019, 15:11 ricksaccous do x amount at a time with some delay in between maybe
# Jul 15th 2019, 15:11 kaliel @lubos you can add a "processed" boolean to each item of your collection, and add multiples tasks with queue plugin
# Jul 15th 2019, 15:11 ricksaccous @lubos you can probably chunk them no?
# Jul 15th 2019, 15:10 ricksaccous in one widget
# Jul 15th 2019, 15:10 ricksaccous and permeating data through different templates
# Jul 15th 2019, 15:10 lubos processing about 9300 results set which does not seems too much though, but there are many fields in the row
# Jul 15th 2019, 15:10 ricksaccous I'm having so much trouble with widgets
# Jul 15th 2019, 15:09 lubos @kaliel I can but I rather write scripts memory wise
# Jul 15th 2019, 15:08 kaliel @lubos So you can increase memory_limit ?
# Jul 15th 2019, 15:07 lubos so far I am setting the memory limit to `ini_set('memory_limit', '512M');` and it works fine, hopefully I am not using too much memory :slightly_smiling_face:
# Jul 15th 2019, 15:05 lubos good way is to use `take` with `while` loop, but in my case i need to merge 2 collections first so I am using ``` $collection3 = $collection1 ->append($collection2) ->sortBy('created') ->take(100) ``` but because the `$collection1` is too large it fails due to memory limit
# Jul 15th 2019, 15:03 lubos I probably can optimize the sql (adding fields list instead of *) so the collettion is not so large and can fit into memory
# Jul 15th 2019, 15:02 lubos @kaliel well I am already executing this on the cli
# Jul 15th 2019, 15:01 kaliel @lubos maybe you can try to defer some process, see cakephp-queue plugin : https://www.dereuromark.de/2013/12/22/queue-deferred-execution-in-cakephp/
# Jul 15th 2019, 14:55 lubos Is there any good way to process large `ResultSet` collections while not increasing `memory_limit`? I am havving allowed memory error with my result set
# Jul 15th 2019, 13:49 ricksaccous i think i know how to go about it actually
# Jul 15th 2019, 13:48 ricksaccous custom nesting label covers no label
# Jul 15th 2019, 13:45 ricksaccous i want a custom inputContainer, no label, and a custom nestingLabel, and a custom checkbox
# Jul 15th 2019, 13:45 ricksaccous is there an easy way to just create a widget that uses x template instead of y template
# Jul 15th 2019, 12:57 okelet hi all, i am trying to use custom column types in my migrations, as said in http://docs.phinx.org/en/latest/migrations.html#custom-column-types-default-values, but the doc is not clear for me. how could I create mysql generated stored columns, like in this post https://stackoverflow.com/a/44548610/576138?
# Jul 15th 2019, 12:21 mikelthewebguy :slightly_smiling_face:
# Jul 15th 2019, 12:21 mikelthewebguy I am really amazed after seeing fast response from you guys
# Jul 15th 2019, 12:20 mikelthewebguy but tried this community first time
# Jul 15th 2019, 12:20 mikelthewebguy i am using cakephp from long time
# Jul 15th 2019, 12:18 mikelthewebguy but thank you codehead.. appreciate.
# Jul 15th 2019, 12:18 mikelthewebguy and it worked :slightly_smiling_face:
# Jul 15th 2019, 12:17 mikelthewebguy i just tried escape
# Jul 15th 2019, 12:17 mikelthewebguy yes
# Jul 15th 2019, 12:17 mikelthewebguy I tried that too
# Jul 15th 2019, 12:17 conehead ``` $this->Url->build([ "controller" => "tools", "action" => "getTools", "?" => [ "param1" => "val1", "param2" => "val2" ] ], ['escape' => false]); ```
# Jul 15th 2019, 12:17 dereuromark please read the docs, you are not using '?' for assigning query string
# Jul 15th 2019, 12:14 mikelthewebguy funny thing is that if we try to do urldecode its not converting andamp; back to and
# Jul 15th 2019, 12:14 mikelthewebguy *querystring
# Jul 15th 2019, 12:14 mikelthewebguy it shouldn't encode querystrin
# Jul 15th 2019, 12:13 mikelthewebguy Its generating wrong querystring
# Jul 15th 2019, 12:13 mikelthewebguy right
# Jul 15th 2019, 12:12 conehead you mean `and => andamp;` right?
# Jul 15th 2019, 12:12 conehead Looks like an encoding problem for me