Dear Hüseyin Çağrı Bayraktar,
If we can describe the issue you encountered as "earlier it worked fast enough, now it works slowly", then typically you can solve it via MS SQL maintenance activities.
Try doing the following:
- in MS SQL Server, create your DB's backup
- in MS SQL Server, create a maintenance plan for your DB
- in the maintenance plan:
** create and configure a scheduled update statistics task (to this task, you can add the task that clears the procedure cache)
** create and configure a scheduled index defragmentation task
** create and configure a scheduled index rebuilding task
Check that you successfully ran the maintenance plan at least once and then check whether you have search performance improvements.
Best regards,
Vladimir Gurov