AnsweredAssumed Answered

Search web script + Transactional update cache full problem

Question asked by lista on Mar 27, 2012
Latest reply on Mar 30, 2012 by lista
I have a Java backed web script that's in charge of searching; and a custom app on top of Alfresco.

I execute that search when visiting a certain tab, meaning, user doesn't get any chance to enter some variables to narrow down the search results. Query then ends up being only an aspect search. And since there's a fair amount of nodes in repository, I get "Transactional update cache full" warnings, query takes forever (minutes), and the whole user experience is awful.

How would you tackle this problem (apart from the obvious, setting a larger transactional cache limit)?