Language: 
To browser these website, it's necessary to store cookies on your computer.
The cookies contain no personal information, they are required for program control.
  the storage of cookies while browsing this website, on Login and Register.
Welcome, Guest. Please login or register.
Did you miss your activation email?


Login with username, password and session length

Select language:

Community



Donate

Donate for PortaMx !
Your donation is safe and helps support the issues and causes you care most about.

Stats

  • *Total Members: 4319
  • *Latest: thygrim

  • *Total Posts: 15781
  • *Total Topics: 2384
  • *Online Today: 4
  • *Most Online: 157
(27.08.09, 03:54:53)
  • *Users: 0
  • *Guests: 1
  • *Total: 1

Author Topic: [Paid if necessary] Board news query optimization  (Read 3466 times)

0 Members and 0 Guests are viewing this topic.

Offline FaintRush

  • Newbie
  • *
  • Posts: 19
Hi all, I'm running my website on a good vip hosting and all pages open almost instantly, except of the main page, it opens for like 3 seconds - the difference is quite visible (check it - www.dota2zone.su).
A minute of testing - and the fact that board news block slows the portal becomes obvious - it starts to open instantly when i remove it.
The only reason for that (that i understand) could be bad SQL query to the database.
Post in this topic or in my skype: faintrush with any possible solutions.
Thanks in advance.

Offline feline

  • CO PortaMx corp.
  • Administrator
  • *
  • Posts: 5586
  • Gender: Female
Re: [Paid if necessary] Board news query optimization
« Reply #1 on: 12.03.12, 19:59:48 »
The block Board News use the SMF SSI function ssi_boardNews ...
Many are stubborn in relation to the path, a few in relation to the target.

Offline FaintRush

  • Newbie
  • *
  • Posts: 19
Re: [Paid if necessary] Board news query optimization
« Reply #2 on: 13.03.12, 19:27:24 »
So..? Is there still anything that can be done to make it faster?

Offline hartiberlin

  • Charter Member
  • *
  • Posts: 792
  • Gender: Male
    • Free energy research
Re: [Paid if necessary] Board news query optimization
« Reply #3 on: 13.03.12, 20:43:06 »
Fel, So how can we optimize this ?

Is this function so slow ?

Many thanks.

Offline feline

  • CO PortaMx corp.
  • Administrator
  • *
  • Posts: 5586
  • Gender: Female
Re: [Paid if necessary] Board news query optimization
« Reply #4 on: 13.03.12, 23:19:18 »
Is this function so slow ?
No .. see you here slow queries ? never  :)

Page created in 0.075 seconds with 11 queries.
Many are stubborn in relation to the path, a few in relation to the target.