record numbers sounds reasonable (though 1951 is still a large number), but you should truncate log file by performing a website backup (with log truncation).
if the error persists, check DNN Eventlog (in admin menu) for associate item and post details here.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

1 mb looks fine for transaction log.
93 k records in search table is reasonable as well, i.e. I fear, the issue is caused by the large number of folders.
Grab the script attached to https://dnntracker.atlassian.net/browse/DNN-3365 and run it from Host > SQL.
Restart the application and check, whether it is working now.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

Thank you for your support Sebastian,

I removed "GO" part from the SQL statements and run the statements one by one. It worked after trying few more times a same statements. (Same if I couldn't run the SQL within less then 30 seconds.)

However worked all SQL statements.

Now Folders - 1953

I just checked the db data file and it is 428608 KB. Is this reasonable? Yes. I have lot of data in my site like a blog. Log file is still 1024 KB.

The site performance is still same. But I did try with creating one page from a old page. It worked without a problem like before. But I need to do the whole thing in a few seconds. Otherwise nothing happened to the changes.

Still can I have a chance to improve the performance like before? (before a year, the same site performed well than now.)

Actually the site is getting too slow day by day..

Please can you advise?