I've done that - still the long pause.

i dont understand why it would be doing this, ive been running this script on differnt shared hosts for the longest time and never had a problem :\

Right - I just logged out and tried it and it loads straight away.

I can't explain why, but maybe this will help narrow it down.

Ok - from /myvbindex.php?explain=1 I see this:

Query: SELECT count(*) AS count FROM post WHERE dateline>='1062795588'
Time before: 0.075654983520508
Time after: 7.8819960355759

I know it is only something that effects logged in users.....

I am assuming the above is checking the number of posts since the last visit - which isn't a standard vBulletin figure right?

I removed the welsome box that holds this info but it still gets stuck on it, so I assume this is something that is checked if the user is logged in, regardless of which templates are being used.

I am quite happy to lose this figure from the script.

Assuming the above is correct, how would I go about removing the bit that does this post count check?

Thanks.

Found it - I have removed this from myvbindex.php:

$getnewposts=$DB_site->query_first("SELECT count(*) AS count FROM post WHERE dateline>='$bbuserinfo[lastvisit]'");
$newposts = number_format($getnewposts['count']);

In the "Welcome" templete I changed:

<a href="$bburl/search.php?s=$session[sessionhash]&action=getnew">New Posts</a>: $newposts<br>

to

<a href="$bburl/search.php?s=$session[sessionhash]&action=getnew">Show New Posts</a><br>

If anyone can figure out what is causing this bit to slow things up, do let us all know.

It now loads within one second!

if I have more than 1 database and forum on my site and have the myvbindex page as a portal. How do I set the cookies so that both databases operate normally? Also how will that login panel work on the myvbindex portal, which database will it go to?

Any tips on how to do all this. Basically right now I just have the one database but Im trying to add another forum to the site.

@arracing it will select whatever database for your site that it you have it set to change directorys for :\, about cookies im not sure :\ ive never goten it to work quite right personally.

@Mike, i asked if you turned all the options off and it looks like you havent, GO INTO the admin cp and turn on and off each setting and watch the load time for each one, this will help you figure out whats causing the drastic load times

my guess would be Latest Forum Topics(very active and l;arge forum)
Home Stats queerys the database for the top poster wich with your forums size could be a problem
and maybe acitve users, due to the fact that if your loged in it checks for buddys lists(i think)

I set the cookie domain for the forum affecting the myvbindex portal to teamrevolution.net and set the cookie to save in the forum directory that its using so /forums/

Then I set my other new forum (database) cookie domain to divisions.teamrevolution.net and the cookie to save in forum directory /divisions/

However when I log in using the individual forums it works fine but when I use the myvbindex login box it doesnt log me in.
I dont understand why because i set one of the settings to affect the entire domain so it should log me in.

Has anyone got more than 1 forum to work right with myvbindex. Please post if you do.

See my posts above. I did turn everything off and the same happened. I've fixed it now (see above).

Okay I have been messing with these cookies and this is where I am at.

Forum1 (v2.3.0 forums includes the myvbindex)
Forum2 (V3 beta 5 forums)

Forum1 cookie domain is .teamrevolution.net and path is /forums

Forum2 cookie domain is blank and path is /divisions

Now both forums stay logged in and that works just fine.
The thing that doesnt work is the login box for myvbindex. When I try and log in to that login box it says thanks for logging in and then returns me to the myvbindex page and doesnt actually log me in. I want that log in box to control Forum1 since that is my big main forum. Forum 2 is an exclusive special forum for certain people.

It just doesnt make sense to me why those settings are not working. I mean Forum one domain says the cookie should effect the whole domain however it doesnt and only effects the /forums

Any help is appreciated. I dont want to have to do away with the login box on the myvbindex but I will if I have to because that is the only thing not working. I still think their should be some fix for this. I cant be the only person with more then 1 forum on a domain using a portal.