11
zagreb1
Re: Slow XOOPS after installing news 1.44
  • 2006/8/14 13:10

  • zagreb1

  • Just popping in

  • Posts: 20

  • Since: 2005/9/10


It all started with news 1.44 installation, so this isn't a problem. Images are linked from the site, and from the web. Problem is in module, it starts slowly, and it slows down the entire XOOPS, as well as other applications.

If You red this

XOOPS took 20.866 seconds to load.
XOOPS Boot took 1.261 seconds to load.
Module init took 0.152 seconds to load.
XOOPS output init took 17.364 seconds to load.
Module display took 1.908 seconds to load.
Page rendering took 0.166 seconds to load.

You'll see that the XOOPS is the problem, not the images, images are catched in the browser. You may register and try to submit the news (Podnesi vijest), You'll see that the problem is in XOOPS output.

12
zagreb1
Re: Slow XOOPS after installing news 1.44
  • 2006/8/16 18:33

  • zagreb1

  • Just popping in

  • Posts: 20

  • Since: 2005/9/10


Such a great assistance...

13
davidl2
Re: Slow XOOPS after installing news 1.44
  • 2006/8/16 19:38

  • davidl2

  • XOOPS is my life!

  • Posts: 4843

  • Since: 2003/5/26


Please remember that we're volunteers, and we may be working or sleeping during the few hours in between your posts...

14
Bender
Re: Slow XOOPS after installing news 1.44
  • 2006/8/16 19:48

  • Bender

  • Home away from home

  • Posts: 1899

  • Since: 2003/3/10


Ok, here we go.

First to be said news is a very common and widely used module. If this were a general problem of the module there should(!) be more reports of this kind of issue.

Not guaranteed but more likely therefore this is caused by the configuration of your server in combination with this specific version of XOOPS or news module or some problem with the database.

Now what i would do is this:

- download the site. set it up locally using Xampp for example and see if it shows the same behavior

- setup another fresh XOOPS on your webserver into a subdomain and (separate) database and see if it also happens there

- dump a copy of the news tables into that test setup again checking if it happens also

This should give some more clues in which direction to continue searching.

Also you said you had troubles when upgrading and messed around in the database manually if i am not mistaken. Did you try to optimize/repair tables afterwards?
Sorry, this signature is experiencing technical difficulties. We will return you to the sheduled signature as soon as possible ...

15
zagreb1
Re: Slow XOOPS after installing news 1.44
  • 2006/8/16 20:00

  • zagreb1

  • Just popping in

  • Posts: 20

  • Since: 2005/9/10


Quote:

davidl2 wrote:
Please remember that we're volunteers, and we may be working or sleeping during the few hours in between your posts...


Those were two days. And I reported this several days ago.
Ok, never mind.

16
zagreb1
Re: Slow XOOPS after installing news 1.44
  • 2006/8/16 20:08

  • zagreb1

  • Just popping in

  • Posts: 20

  • Since: 2005/9/10


Quote:
Bender wrote:
Ok, here we go.

First to be said news is a very common and widely used module. If this were a general problem of the module there should(!) be more reports of this kind of issue.

Not guaranteed but more likely therefore this is caused by the configuration of your server in combination with this specific version of XOOPS or news module or some problem with the database.


Could be.
Just for sure: how much the "keywords" and description" take time in database operating?

Now what i would do is this:

Quote:
- download the site. set it up locally using Xampp for example and see if it shows the same behavior


Ok, I'll try to do it.

Quote:
- setup another fresh XOOPS on your webserver into a subdomain and (separate) database and see if it also happens there

- dump a copy of the news tables into that test setup again checking if it happens also

This should give some more clues in which direction to continue searching.


Well, first I setup a fresh 2.0.14 with 1.44 in a new database (empty one), and everything work fine.
Also, some more tips. It works well in the morning, but lousy during the evening.

Quote:
Also you said you had troubles when upgrading and messed around in the database manually if i am not mistaken. Did you try to optimize/repair tables afterwards?


This is a problem. Some big tables I ussualy can't repair, and "stories" is big (20 MB). When I do it, base colapse and nothin woorks for several minutes.
Ok, I'll add this: "stories" encrease their size each time i post na new article a lot. Then I must perform optimize, and after that base crashed and become unreachable for several minutes, then it appears with decreased size.

17
zagreb1
Re: Slow XOOPS after installing news 1.44
  • 2006/8/19 18:40

  • zagreb1

  • Just popping in

  • Posts: 20

  • Since: 2005/9/10


I'b back.

Ok, I instaled fresh new XOOPS 2.0.14. on localhost, add all modules and mods, complete database and it works fine.

I can normaly repair and optimize database.

Does anybody have problem with database repairing and optimizing for large tables ?

Also, when I install fresh Xoops, tables have prefix xoops_, and in my XOOPS (upgraded one) they have prefix table_xoops_

Is there a problem ?

Also, the database on localhost has 22,5MB, on host it has 20,6MB....

Login

Who's Online

299 user(s) are online (186 user(s) are browsing Support Forums)


Members: 0


Guests: 299


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