YAF Performance page loads · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

Zero2Cool
100% (Exalted)
YAF Leader Topic Starter YAF Version: YAF 3.1.16

13 years ago

How is the time calculated with the "This page was generated in 2.142 seconds." label?

I'm trying to figure out why my site is so slow. If it's the host, if I have too many posts (nearly 200k) or if maybe when I imported about 160k posts it broke something... I'm at a loss.

If the page time is generated by the start and completion of the stored procedure, that would mean my database is too big for the database server specs, right?

Edit, This page was generated in 0.034 seconds. <-- I want times like that on my site!! 🙂

Edited by user 13 years ago | Reason: Not specified

Wanna join the discussion?! Login to your YAF.NET Support Forum forum account or Register a new forum account

Sponsor

Jaben
100% (Exalted)
YAF Developer

13 years ago

Hehe. It's possible! If you compile YAF.NET with DEBUG turned on and are logged in as admin it will give you exact times to make database calls. That would help you diagnose what part of the site is slow.

Another idea is to use the DB tools in the Admin to run reindexing on your database... that might help speed things up too.

Zero2Cool
100% (Exalted)
YAF Leader Topic Starter YAF Version: YAF 3.1.16

13 years ago

I'll have to figure out how to get YAF running locally and give that a try.

Trimming my database wouldn't help increase page load times then, correct? I think this would be true because the queries essentially select the TOP ##.

I'm doing the reindexing now. This page was generated in 300.024 seconds.

Restarted the application.

Main forum view: This page was generated in 0.851 seconds.

Does the recovery mode play a role in page load speed?

Edit, on my site, I submitted a post and it took This page was generated in 10.361 seconds. I'm thinking this has to be my host that is a pile of crap.

Edited by user 13 years ago | Reason: Not specified

Zero2Cool
100% (Exalted)
YAF Leader Topic Starter YAF Version: YAF 3.1.16

13 years ago

I have a beta site set up and the times are sub 0.1 for the page loads.

http://packersbeta.com/Forum.aspx

That was version 1.9.5.5

Upgraded to 1.9.6 Beta and the times are more the range of 0.5 and higher, sometimes lower.

The site linked above is a small database with no outside hits from anyone. I'm thinking the beta version and my host might not get along too well.

Jaben
100% (Exalted)
YAF Developer

13 years ago

Recovery mode will play a big role in the SIZE of the database... and thus the speed. I recommend setting it to "Simple" recovery as "Full" will be huge quickly.

Zero2Cool
100% (Exalted)
YAF Leader Topic Starter YAF Version: YAF 3.1.16

13 years ago

Recovery mode will play a big role in the SIZE of the database... and thus the speed. I recommend setting it to "Simple" recovery as "Full" will be huge quickly.

Originally Posted by: Jaben

After switching from Full to Simple, should I see a size difference or do I have to empty a table or ... ???

I set it to Simple earlier today and the database appears to be similar in size. I can't check for sure because ... my host is down ... go flippin figure!

Host came up. It reverted back to Full. I set it to Simple again and it's still the same.

Size of database: 491 MB

I'm doing a reindex now.

Edited by user 13 years ago | Reason: POS Host is up again.

Zero2Cool
100% (Exalted)
YAF Leader Topic Starter YAF Version: YAF 3.1.16

12 years ago

Another idea is to use the DB tools in the Admin to run reindexing on your database... that might help speed things up too.

Originally Posted by: Jaben

With the help of the_watcha, squirrel and bbobb I've removed DNN and am running YAF essentially stand alone. I'm getting speeds the same as here. And it's freeeeeeeaking awesome!!! 🙂

squirrel
100% (Exalted)
YAF Leader

12 years ago

I've always praised DNN as a CMS, but when it comes to performance, it has turned into such a bloated monster that it is not usable for anyone who is not willing to sit on a dedicated server - no matter what the size of the site... I used to use it and spent almost 2 years getting all the data into it from my various 'site versions' that had been accumulated over the years... As my traffic slowed down (mainly due to competing sites stealing my content and posting it on their sites to draw my traffic), I noticed that DNNs resource usage did not slide down as the traffic did. It didn't matter if I served 10,000 pages or 10 in a day, it still sat there consuming over 500mb of ram if not closer to 750mb, and the database size was also a factor with all their logging and error trapping that can't be turned off...

With a few options to disable logging of everything the app does, it could be so much better on the DB side, but that still wouldn't solve the resource hogging that it does... I could see that kind of memory consumption if the site was doing business heavily, but when it was serving nobody and still consuming processor and RAM, it wound up being more load than it was ever worth...

Glad we could help get you away from the beast -- it's a good CMS and application, but it is no longer for the 'faint of heart' let alone for any server that is not dedicated to it's purpose...

If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend

Zero2Cool
100% (Exalted)
YAF Leader Topic Starter YAF Version: YAF 3.1.16

12 years ago

I really enjoyed DNN, but the resources it used were really effecting my site and I wasn't utilizing anything on DNN that I couldn't myself develop through ASP.NET pages.

I think DNN would be great for a company as an intranet site, or if you have a dedicated server to host it from. But when you have a simple hobby site, it's a little unrealistic financially.

Important Information: