Search is very slow and sometime fails

The search feature is very slow using the ‘basic’ or ‘advanced’ search. I have also tried using the Reports modules to do searches and that is just as slow and gives empty results.

Is there any way of seeing that the sql that is being generated to begin to understand/debug this issue? I am on the latest 7.* version (I can remember which).

Let me know,

You should enable log slow queries in the Admin page and see what gets logged.