# |
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 |
# |
Jul 15th 2019, 12:11 |
mikelthewebguy |
Anyone has any idea about this ? |
# |
Jul 15th 2019, 12:11 |
mikelthewebguy |
"?get-history?customerId=1andisData=1" |
# |
Jul 15th 2019, 12:11 |
mikelthewebguy |
Instead of: |
# |
Jul 15th 2019, 12:11 |
mikelthewebguy |
Its generating querystring as "?get-history?customerId=1andamp;isData=1" |
# |
Jul 15th 2019, 12:10 |
mikelthewebguy |
$this->Url->build(['controller' => 'History', 'action' => 'getHistory', 'customerId' => '1', 'isData' => '1']) |