Hari KT
-
Posts
131 -
Joined
-
Last visited
Everything posted by Hari KT
-
Thank you @teppo for pointing about the QueryLog. Sometimes I forget things, my bad.
-
Hey, So this have already been asked by some, and I have noticed your replies that Processwire is very fast, and if not you can cache the results. And I agree the same, still I have a question. We have around 6,00,000 ( 6 Lakh ) pages, and PW can deliver in ~1.9 to ~4 seconds. ie really awesome thing. One concern is at times it goes slow to ~5 seconds to 8 seconds ( I am talking about onload speed in browser , not the rendering speed ). So in my findings the problem is like we have a few cron jobs running via gearman to insert and update certain images and more than that . We are using PW Page api to do the insert / update stuffs. ( May be around a few 1000's of pages are fetched and process at a time ) . The question is whether there is a way to get the raw sql queries that we need to run on a single insert / update of a Page . Eg : $page = $this->pages->get("id={$data->article_id}"); if ($page->template == 'something') { $date = new DateTime(); $page->update_field = "Some data" $page->save(); } So the idea if I know the row sql query to run, we can get and insert via pdo with out the api and see how fast is it processing. Let me know if there is a way for the same. Also if you have any other suggestions / optimization tips I am Happy to hear and take. Thank you.
-
RT @shameerc: Regsitered for #AngelHack #Dubai Spring 2014. Anyone joining in? http://t.co/JUzwqgaxg3
-
Pushed some code to make browse and read work in @pmjones ADR stuff . See in feature branch https://t.co/vyHsZBwb7M supported with #Composer
-
RT @Gramener: The geography of candidates' wealth: http://t.co/f9kzoUPnzQ http://t.co/Qq5o2ecw2Z
-
RT @matthiasnoback: And a special thanks to @bopp who convinced me to make the step from WordPress to @getsculpin and @disqus!
-
RT @matthiasnoback: My restyled blog is now online: http://t.co/chcnKyOjTH Let me know what you think! Does it work on your machine?
-
RT @planetphp: The rise of Composer and the fall of PEAR - Fabien Potencier http://t.co/8DJ6vc9X7n
-
oh @pmjones I hate to say again : Please keep a link to @auraphp in http://t.co/IETzHYkG8X website.
-
I am not an expert, but I feel the _generateKeys could use something better like https://github.com/ircmaxell/RandomLib ( He is an expert in security http://stackoverflow.com/users/338665/ircmaxell )
-
Thank you Craig.
-
RT @koredn: We opened the Call For Papers (with a twist) for the PHP room @froscon: http://t.co/m92nNv03Xm – please RT and forward to user …
-
There was a change in name aura/sql-query to aura/sqlquery . You can find in #packagist https://t.co/i5k20iB1Rk #composer #auraphp
-
Killer feature discussion of @auraphp https://t.co/hgCdsNOOD0 . Interested to hear more features / insights from the #php world.
-
So played a bit with @heroku . @auraphp deployment was so easy. Something I built simply for fun http://t.co/KDzdsERRpO
