1
trabis
Site slow? Using news module? Read this!
  • 2008/1/23 20:42

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


Here is the deal,
My site was becoming slower day by day so I change server.
Now after 3 months godaddy comes and says: "resolve your problem or buy dedicated server".

I was about to purchase a dedicated server but I had good news!
Your problem is in "modules/news/article.php" they said

So I went to see.

I put counters all over the code and I was able to isolate a function that took me 3 seconds to load.

That is the function responsible for showing previous and next link.

This function does a query without any limit to the database meaning that if you have 15.000 news and 100 users online as i do you will get in serious trouble (and it will get worse news by news as the query becomes longer).

So for thoose of you who might have the same problem I recomend to disable "Show Previous and Next link" in the news administration until we get a better way to get thoose links from the database.

That´s it!

2
Anonymous
Re: Site slow? Using news module? Read this!
  • 2008/1/23 20:47

  • Anonymous

  • Posts: 0

  • Since:


Perhaps you could send a PM to Hervé with a link to this thread (just in case he misses it)?

3
trabis
Re: Site slow? Using news module? Read this!
  • 2008/1/23 21:13

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


Yes I should, PM is on the way :)

4
avtx30
Re: Site slow? Using news module? Read this!
  • 2008/1/24 3:46

  • avtx30

  • Not too shy to talk

  • Posts: 181

  • Since: 2006/10/12


Thanks for the info.

Please post your XOOPS version and news version too!

5
christian
Re: Site slow? Using news module? Read this!
  • 2008/1/24 5:53

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


Hi

Can you look this article publish by Instant-Zero .

6
qcorek
Re: Site slow? Using news module? Read this!
  • 2008/1/24 12:36

  • qcorek

  • Just popping in

  • Posts: 68

  • Since: 2007/10/7


very helpful - thx

7
trabis
Re: Site slow? Using news module? Read this!
  • 2008/1/24 13:23

  • trabis

  • Core Developer

  • Posts: 2269

  • Since: 2006/9/1 1


@avtx30: My version is 1.53 but doesn´t matter, it goes true every version. Hervet is looking into it so he will get a turn around, I´m sure.

@Christian: Yes I read the above link, is very helpful, but is not related with this issue.

My site has never been faster, I´m so glad I found this, and I´ll sure pay more atention to this kind of problems. Thank you all.

8
script_fu
Re: Site slow? Using news module? Read this!

Thanks for the post. I will be on the lookout for this. I always use the news module on all my sites. I hope this will make it better for my server.

9
Peekay
Re: Site slow? Using news module? Read this!
  • 2008/1/28 14:26

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


Nice detective work Trabis. I use News 1.53 too. I hope a fix becomes available for the prev/next feature as it is useful.
A thread is for life. Not just for Christmas.

Login

Who's Online

165 user(s) are online (99 user(s) are browsing Support Forums)


Members: 0


Guests: 165


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits