Hello everybody,

After long and unsuccessfull tries and searchs, I'm asking for help about a problem that finder generates on my website:

Among my installed modules, I have on my website
- Finder 7.x-2.0
- Views 7.x-3.7
- Commerce 7.x-1.5

I created a search block on my whole website, managed by finder, which is working perfectly but slow the performance of my whole website. With Finder activated, each page loads between 10s and 15s, without, it comes back to 3s-5s.

Here are some screenshots of my database log, with finder activated (2 tries: 12091,92ms and 9353,71ms) and without (2 tries: 2192,06ms and 1691,64ms). We can see that the problem is coming from the drupal cache (INSERT INTO cache_views, INSERT INTO cache_forms ) which seems to be reconstructed every page when finder is activated.

With finder activated (click on the pictures to enlarge them)
withfinder
withfinder
Without finder activated
withoutfinder
withoutfinder

I tried many solution without success : activating APC, Memcache, Playing with views cache, with finder cache as well...

Any suggestions? Thanks you!

CommentFileSizeAuthor
withoutFinderoncommerceview-2.jpg283.98 KBdg888
withoutFinderoncommerceview.jpg298.89 KBdg888
withFinderoncommerceview-2.jpg303.84 KBdg888
withFinderoncommerceview.jpg349.3 KBdg888

Comments

askit’s picture

askit commented

I have exactly same problem here. Without Finder, the page completes around 1s. With Finder, it takes from 5s to 10s. Any clues on resolving this will be greatly appreciated!

askit’s picture

askit commented
Issue summary: View changes

pictures links

danielb’s picture

danielb commented

Sorry I don't know. I have a line in there telling Views not to cache the query

$view->is_cacheable = FALSE;

and Finder has it's own separate cache that I don't see being used in those screenshots.

If you can tell me how to improve things in regards to views caching I'm all ears. It certainly doesn't seem like the views cache query is contributing to all the slow loading problems here. Perhaps the configuration of the finder makes it very hefty. See also https://www.drupal.org/node/1971420

danielb’s picture

danielb commented
Status: Active » Closed (won't fix)