| # |
Dec 14th 2017, 07:27 |
furqan |
so ,to give little more background ,when i try this query through ORM ,it takes 20 secons / write and the same with raw sql within this mehod on same table and everythin els ebeing same is much much more faster |
| # |
Dec 14th 2017, 07:26 |
furqan |
No its again the same 20 seconds delay ,for the query /queries to get executed via ORM |
| # |
Dec 14th 2017, 07:24 |
joopm |
okey wait for the result |
| # |
Dec 14th 2017, 07:24 |
furqan |
had to restart server and all |
| # |
Dec 14th 2017, 07:24 |
furqan |
just 1 minute |
| # |
Dec 14th 2017, 07:21 |
joopm |
did it help? |
| # |
Dec 14th 2017, 07:21 |
furqan |
Thanks on it |
| # |
Dec 14th 2017, 07:20 |
joopm |
i wait for that for a ahile |
| # |
Dec 14th 2017, 07:19 |
furqan |
wait i willlet me change it to 127.0.0.1 and see if that fixes it |
| # |
Dec 14th 2017, 07:19 |
furqan |
n in my office its just giuving me nightmare |
| # |
Dec 14th 2017, 07:19 |
furqan |
so in my home laptop ,its working just fine with teh exact same configuration and exact same code base |
| # |
Dec 14th 2017, 07:18 |
joopm |
in phpmyadmin? |
| # |
Dec 14th 2017, 07:18 |
joopm |
how do you mean my home box? |
| # |
Dec 14th 2017, 07:18 |
furqan |
okay let me try that out first |
| # |
Dec 14th 2017, 07:18 |
furqan |
so i thing has to do with the envoirnment |
| # |
Dec 14th 2017, 07:17 |
furqan |
but the exact same piece of code is working just fine in my home box ,exact same os -cent os ,and the same code base |
| # |
Dec 14th 2017, 07:17 |
joopm |
for me it was that reason |
| # |
Dec 14th 2017, 07:17 |
joopm |
it will help sure |
| # |
Dec 14th 2017, 07:17 |
joopm |
yes change it |
| # |
Dec 14th 2017, 07:17 |
furqan |
will try that now |
| # |
Dec 14th 2017, 07:17 |
furqan |
its localhost ,and i was asked to change it to 127.0.0.1 |
| # |
Dec 14th 2017, 07:17 |
joopm |
its happened to me when using localhost became extremely slow |
| # |
Dec 14th 2017, 07:17 |
furqan |
i have already set debug kit up ,but the queries are not directly executed in cake context ,there is a woker /background job processing cakeresqueue que that executes the logic/queries |
| # |
Dec 14th 2017, 07:16 |
joopm |
or exact ip address? |
| # |
Dec 14th 2017, 07:16 |
joopm |
localhost? |
| # |
Dec 14th 2017, 07:16 |
joopm |
what do you use in the config? |
| # |
Dec 14th 2017, 07:16 |
furqan |
Hi guys ,i was running into an issue ,wherein a query executed through cakephp ORM takes 20 seconds and the same through raw sql takes < 1 ,i had come to this portal and i was suggested to dump sql queries by debug kit |
| # |
Dec 14th 2017, 07:12 |
joopm |
good morning to all community memberss |
| # |
Dec 14th 2017, 07:10 |
 dereuromark |
make it a plugin solution and get some crowd-help :slightly_smiling_face: |
| # |
Dec 14th 2017, 06:10 |
braeden |
:,( |
| # |
Dec 14th 2017, 06:10 |
braeden |
... designing an activity feed sucks |
| # |
Dec 14th 2017, 05:39 |
megan |
awesome, thanks hmic :slightly_smiling_face: |
| # |
Dec 14th 2017, 05:23 |
meder_ |
is there a cake convention to plural vs singular? if i have an API route for /users/ and a separate one for /users/:id, what's the "cake" way of defining the function for each of those within the same controller? |
| # |
Dec 14th 2017, 05:17 |
braeden |
What sort of UUID is CakePHP using? It isn't a timestamped UUID is it? |
| # |
Dec 14th 2017, 03:00 |
admad |
It's not, you need to handle converting timezone of the object yourself |
| # |
Dec 13th 2017, 22:42 |
phantomwatson |
If I save an record with `time` of `Time('2017-12-17T15:00:00-05:00')`, does `time` in the database get saved as `15:00:00` (local time) or `20:00:00` (UTC time)? In other words, I'm not sure if the offset is taken into consideration when the `Time` object is transformed into a string for SQL. |
| # |
Dec 13th 2017, 22:11 |
ericadeefox |
where do you load HtmlHelper? can I see the full code? |
| # |
Dec 13th 2017, 22:10 |
ericadeefox |
House, we've got a patient where all the global variables are unset as soon as the method runs through, but the method still runs and the variables aren't unset as long as `dd($_POST)` is the last line of the method. |
| # |
Dec 13th 2017, 21:39 |
joopm |
but deleting it makes Error: htmlHelper could not be found. |
| # |
Dec 13th 2017, 21:38 |
joopm |
there is nothing special in that line <?php $this->Html->link(__('List'), ['action' => 'index']); ?> |
| # |
Dec 13th 2017, 21:38 |
joopm |
in a view file if i delete a line i lose my htmlHelper |