# |
Jul 15th 2019, 15:16 |
lubos |
so using endless group and sql with `limit (number, from)` is the way to go I guess :slightly_smiling_face: |
# |
Jul 15th 2019, 15:15 |
lubos |
@kaliel but then 101 - 200 created date could be wrongly sorted with first 100 results, but I need to loop sql queries with short period at this case I think :slightly_smiling_face: |
# |
Jul 15th 2019, 15:14 |
kaliel |
@lubos you can sortBy('created') the first 100 results, then query for the 101th to 200th, etc... |
# |
Jul 15th 2019, 15:14 |
lubos |
is using `512MB` too much? :slightly_smiling_face: |
# |
Jul 15th 2019, 15:13 |
lubos |
but so much easier to increase memory limit |
# |
Jul 15th 2019, 15:13 |
lubos |
thanks both, i will do |
# |
Jul 15th 2019, 15:13 |
lubos |
but I guess I can make sets limited by short period, e.g. day or so |
# |
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 |