| # |
Dec 14th 2017, 09:10 |
furqan |
hey morning there ! |
| # |
Dec 14th 2017, 09:10 |
slackebot |
$routes->connect('/users', ['controller' => 'Users']); }); ``` and ``` Router::plugin('Admin', ['path' => 'admin'], function ($routes) { $routes->connect('/users', ['controller' => 'Users']); }); ``` when should I use one and when should I use another ? whats is the implications of each other? I need to create an "admin" area for manage (eg, a blog system) , which can be the best option and why? Thanks |
| # |
Dec 14th 2017, 09:10 |
 psantos |
hello everybody What's the difference between those codes: ``` Router::scope('/admin', function (RouteBuilder $routes) { $routes->connect('/users', ['controller' => 'Users', 'action' => 'index']); }); ``` ``` Router::prefix('admin', function($routes) { $routes->connect('/users', ['controller' => 'Users', 'action' => 'index']); } ``` ``` Router::scope('/admin', ['plugin' => 'Admin'], function ($routes) { |
| # |
Dec 14th 2017, 09:09 |
furqan |
i have installed debugkit ,i am looging the sql queries to the log file |
| # |
Dec 14th 2017, 09:09 |
neon1024 |
Morning everyone |
| # |
Dec 14th 2017, 09:09 |
furqan |
any one !!! |
| # |
Dec 14th 2017, 07:47 |
furqan |
if it would log those queries also ,can u tell me how do i configure ,bacause by default it just logs in the queries in the web request -response cycle |
| # |
Dec 14th 2017, 07:46 |
furqan |
because the code is executed by the background jo processing engine resqueue |
| # |
Dec 14th 2017, 07:46 |
furqan |
okay ,so someone from teh portal suggested yestarday to get debugkit and to log queries and see ..So i do have the cakephp debugkit ,but will it also log the queries executed by the background workers as in the resqueue workers |
| # |
Dec 14th 2017, 07:39 |
joopm |
i dont have idea yet |
| # |
Dec 14th 2017, 07:32 |
furqan |
takes 20 seconds ,i am logging the results to a log file that have timestamp ! |
| # |
Dec 14th 2017, 07:31 |
furqan |
$result = $this->Event->save($event); |
| # |
Dec 14th 2017, 07:31 |
furqan |
this 1 takkes < half a sec |
| # |
Dec 14th 2017, 07:31 |
furqan |
$this->Event->query("insert into events (org_id,date,info, user_id ,uuid,published,analysis,attribute_count , orgc_id , timestamp ,distribution , sharing_group_id , proposal_email_lock , locked ,threat_level_id , publish_timestamp , disable_correlation ) values(1 ,'2017-09-18', 'furqan_test_event' , 9 , '42bfaf6e-3347-4c81-bc76-088372452682' ,0, 1, 2 ,1 ,1508771790 ,1 ,0 ,0 ,0 ,1 ,1505829657 ,0 )"); |
| # |
Dec 14th 2017, 07:28 |
furqan |
yes please ,thanks for your time |
| # |
Dec 14th 2017, 07:28 |
furqan |
i have tried out increasing buffer_pool_size ,writing to other tables ,logging and etc..But it just doesnt seem to get to the root cause |
| # |
Dec 14th 2017, 07:28 |
joopm |
oh i have to think about it |
| # |
Dec 14th 2017, 07:27 |
furqan |
in milliseconds |
| # |
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 |