XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk


« 1 2 (3)


21
Gombunan
Re: Number of DB queries increases during busy period?

  • 2005/6/7 18:44

  • Gombunan

  • Just popping in

  • Posts: 30

  • Since: 2005/5/14


Thank you mOnty and wtravel for responding

I tried disabling the Who's Online block and the number of queries dropped to 10 or 11. Wow that's such a big difference!

The Who's Online block is very useful and informative and I want it to be accessible to the registered users. So may be I'll cache it for 30s or something. But I know some weird effect may appear because of this caching.

During peak time, my site gets over 150-200 or more visitors on the main XOOPS pages and over 200-300 in the forum alone. And the number will only gets bigger in the coming weeks due to the seasonal nature of my website.

Earlier today my server crashed and I have to repair the xoops_session table as a result. I hope this didn't cause the problem. Is there a way to optimize the Who's Online block besides caching?
Topic | Forum


22
Gombunan
Number of DB queries increases during busy period?

  • 2005/6/7 17:43

  • Gombunan

  • Just popping in

  • Posts: 30

  • Since: 2005/5/14


I am wondering why does the number of database queries increases for my site when it gets busier.

For example, my Poll page gets 17 to 20 queries when I am the only one logged on (when I disabled the website from other visitors/users). But as soon as I re-open it and visitors started coming in, the number of queries jumps to 45 and more.

The only blocks on that Poll page are the Poll List, Main Menu, User Menu and Who's Online block.

I suspect the Who's Online block is the one causing the problem. Can anybody confirm this if they have had similar experience?

If it's the Who's Online block, why it is causing the problem?

Thank you.
Topic | Forum


23
Gombunan
Re: Best Discussion Board Module ?

  • 2005/5/16 14:59

  • Gombunan

  • Just popping in

  • Posts: 30

  • Since: 2005/5/14


I use a stand alone phpBB and going to use IPD on my current XOOPS setup.

What I like the most about IPD is the extensive moderating features. Exactly what I need. Haven't tried Invision Board though.
Topic | Forum


24
Gombunan
Re: How to show load time and DB queries to admins and mods only

  • 2005/5/16 14:49

  • Gombunan

  • Just popping in

  • Posts: 30

  • Since: 2005/5/14


Mithrandir,

btw, there's an extra forward slash </{/if}> in the code snippet which causes an error.

Anyway, thank you very much! It works like a charm now.

This is my first attempt into a full fledge CMS to manage my website. After checking around, I like XOOPS the most. I find it to be fast, secure, has many excellent modules, has very nice themes, highly customizable, and low learning curve.

Keep up the good work!
Topic | Forum


25
Gombunan
Re: How to show load time and DB queries to admins and mods only

  • 2005/5/16 7:41

  • Gombunan

  • Just popping in

  • Posts: 30

  • Since: 2005/5/14


Anybody please? May be I posted in the wrong forum, sorry I am new here.
Topic | Forum


26
Gombunan
Re: How do I give rights to moderators to edit/delete comments?

  • 2005/5/15 20:32

  • Gombunan

  • Just popping in

  • Posts: 30

  • Since: 2005/5/14


Opps.. sorry I missed the Comments check box. Thanks.
Topic | Forum


27
Gombunan
Re: How do I give rights to moderators to edit/delete comments?

  • 2005/5/15 20:31

  • Gombunan

  • Just popping in

  • Posts: 30

  • Since: 2005/5/14


Thank you for your reply but unless I missed something, that did't do quite what I wanted.

The comments come from Photo Gallery, News, Polls, AMS modules etc. I don't want the moderators to have admin rights on those modules.

I set up my site so that only the moderators see the Recent Comments block.

I just want the delete/edit buttons besides the reply button appear below the posted comments when they click the comment links.
Topic | Forum


28
Gombunan
How do I give rights to moderators to edit/delete comments?

  • 2005/5/15 19:35

  • Gombunan

  • Just popping in

  • Posts: 30

  • Since: 2005/5/14


Is there a way to allow moderators to edit/delete comments posted by registred users on my site?

Thanks in advance
Topic | Forum


29
Gombunan
How to show load time and DB queries to admins and mods only

  • 2005/5/14 8:22

  • Gombunan

  • Just popping in

  • Posts: 30

  • Since: 2005/5/14


Hello,

I am implementing the load time and DB queries on my page as decribed here:

https://xoops.org/modules/smartfaq/faq.php?faqid=303

I want to show the information to the site admins or moderators only, and it'll be invisible to guests and members.


I tried

<{if $xoops_isadmin = 1 || $xoops_ismoderators = 1}>
<{php}>
echo round(($GLOBALS['xoopsLogger']->dumpTime()), 3)." Seconds | ".count($GLOBALS['xoopsLogger']->queries)." Queries";
<{/php}>

</{/if}>

But that didn't work. I am a begginner in PHP too btw.

Anybody can help? Many thanks?
Topic | Forum



TopTop
« 1 2 (3)



[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

203 user(s) are online (98 user(s) are browsing Support Forums)

Members: 0

Guests: 203

more...

Donat-O-Meter

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

Latest GitHub Commits