PDA

View Full Version : is it normal?


KURTZ
02-07-2008, 01:39 PM
Page generated in 3.57143688 seconds (-63.32% PHP - 163.32% MySQL) with 11 queries

check the stats above ... i've installed only THIS (https://vborg.vbsupport.ru/showthread.php?t=140449) hack on a fresh new board, cause i'm curious about the "slow loading" of my board ...

all the load goes on the Data Base ... is it normal? (consider that my board is sometimes really slowly especially when i try to read/post a new argument)

Lynne
02-07-2008, 01:58 PM
Are you on a shared server or is this your own dedicated server?

KURTZ
02-07-2008, 02:08 PM
shared server, Lynne ... :(

i moved my forum cache on datastore.php, but i don't see great improvements ... i really don't understand that value (163% on mysql)

Lynne
02-07-2008, 02:17 PM
Since it is shared, it is really hard to say whether that is 'normal' because your resources are being used by several sites at the same time. I don't have those microstats on my site, but I do have another and my homepage takes .7 seconds to load with 37 queries. However, I am running my site on two servers.

KURTZ
02-07-2008, 02:23 PM
what "microstats" do you use Lynne? i wanna try those ...

Opserty
02-07-2008, 02:25 PM
If you want stats then just use debug mode for your IP.

KURTZ
02-07-2008, 02:27 PM
If you want stats then just use debug mode for your IP.

how? :rolleyes:

Opserty
02-07-2008, 02:29 PM
You need to edit config.php. I think its:

if($_SERVER['REMOTE_ADDR'] == 'PUT.UR.IP.ERE')
{
$config['Misc']['debug'] = true;
}

KURTZ
02-07-2008, 02:34 PM
so, simply add this code on the top of the file?

Opserty
02-07-2008, 02:42 PM
Doesn't really matter but I put mine at the bottom.

KURTZ
02-07-2008, 02:50 PM
thx Opserty, it runs ... :)

anyway i've a question for you: i saw this: Shutdown Queries: DISABLED maybe this make my board slowly? how i can enable this?

Lynne
02-07-2008, 02:56 PM
what "microstats" do you use Lynne? i wanna try those ...
I use this hack: https://vborg.vbsupport.ru/showthread.php?t=82900 It's similar to yours only doesn't spit out the percentage of php and mysql. If I need more than those stats, then I turn on debug mode.

KURTZ
02-07-2008, 02:59 PM
thx Lynne, runs on 3.7.x?

edit: look the shot, it's ok?

Lynne
02-07-2008, 03:46 PM
It's running fine on 3.7 beta 2 which is what I have on my test board.

It's hard to look at the screen shot you posted and see if everything looks fine for *your* board. I usually use debug to look at the queries and see if variables are getting passed or if I need to index a column for a hack I wrote because a query is getting hung up there or things like that. Is that from the same page you originally posted from because the page generation time is much lower, although there are more queries. You may want to take a look at the queries for the first page you posted and see if the page is getting hung up on one - if you click on the (?) next to the number of queries, a page will come up listing all the queries and the time for each.