Faster Database search

[adrian]

Just now, sreeb said:

Hi @adrian the one to generate an sql query form a pw selector

Just add this to Tracy's Console panel:

$selector = "template=basic-page, title=Contact 2";

d($pages->find($selector)->each("title"));
d($pages->getPageFinder()->find(new Selectors($selector), array('returnQuery' => true))->getQuery(), array('maxLength' => 99999));

I save it as "Selector SQL Generator".

This will return the results of the selector in the first dump and the SQL in the second.

Let me know if you have any troubles with it.

[sreeb]

One more question. We have Pro Cache enabled on our website. Expect for the treefilter, because this is send trought Ajax Post.

Is it possible to use procache when there is a post request?