Can't acess OLD (like 2 yr old) topics. Database problem?

[ZacFields]

Okay as some of you have seen I finally found a PHP4 VPS to move my site to. But while digging around my site on the old server I have come up with some upsetting problems. Here they are:

1. A vanilla beta of 1.4.1 actually runs very respectable pageload times (between 2-3 second pageloads) on the exact same server where my site gets between 8-30 second pageloads. My site has just over 100,000 posts. Is this normal? Am I being unrealistic in thinking that once I move my site from this shared server to a VPS that I will be able to get the pageloads under 5 seconds?

2. Old posts are not accessible on my forums on the old server. For example, when I search for a post from...say 2 years ago, I get all kinds of results, but none of them will load! You click on it and it just stalls and the page will never load.

I am assuming I may have database problems. So here is my question... what if I just installed a completely stock 1.4.0 Integramod onto my new server and upgrade it to phpbb 2.0.21 as that's what my files are. I assume to transfer all my members' accounts over would be pretty easy...but how about transferring over the last couple months worth of posts? Does anyone know how I could do this?

Also, does anyone think possibly moving to the new VPS from the old shared server might just solve the problem of not being able to access really old posts? Any ideas would be helpful. I'd really hate to have to totally start over with a new integramod 1.4.0 with nothing but my users' accounts. Of course I suppose it wouldn't be so bad if I could set up an archive like the integramod archive here.

Zac

[ZacFields]

*UPDATE*

Okay, the new server did fix my pageload times, at least with only me browsing the site I am getting about 1.25 seconds per page load which is amazingly faster.

However, I am still not able to access the older posts. This confuses me, because my database is 218 megabytes so I know the information is in there, I just can't access it. Does anyone have any ideas how I can fix this or what is causing it?

I have re-named this topic to help.

Zac

[Teelk]

It's possible that the cache still exists from the old server. Try clearing it.

Also, you can try running a repair on the database through phpmyadmin.

[ZacFields]

Okay... it appears I was wrong about this. Now I've discovered that they actually will show up...but it takes about 30 seconds pageload to pull them up. This is unusual because on most areas of the forum the pages load in less than 2 seconds.

Is this just simply because they're so far back in the database (I have over 100,000 posts on this forum) that it just literally takes that long to get it? My old server would time out before it would open.

Zac

[Teelk]

Sounds like there might be a lot of overhead on some of your tables. If you haven't done so already, go to phpmyadmin and select all the tables with overhead, then try optimizing them.

[ZacFields]

Okay, done and done.

I do have a question though... when I execute these commands, I get a response really quick that just says "OK" on the status line. What does that mean?

Does that mean that the optimization is done, or does that mean that it has begun and will probably go on for a while if I selected ...say... the post and post text tables?

I was just curious because I selected all the tables for repair and got an instant response that said "ok" for status but then it seemed the page loads began to slow down just a little bit and after a while the sql server crashed. Works fine when I restarted it though.

I'm so new to this VPS stuff . argg <img>

Zac

Zac

[Helter]

have you added a mod sometime after tha offending posts that adds info to the post table? It is possible that your forum is looking for a field, or fields that are blank on your old posts.

[ZacFields]

hmm... I don't think so. But you know I could very well be wrong. I think all that I've done is upgrade IntegraMod a couple times.

It's not a huge deal, since people can still see the stuff...it just takes like 30 seconds to load it.

Umm... What would be the best way to find out? Just compare the table structure in my posts table to that of a bone-stock integramod? I couldn't even tell you when this started because on my old server, all the pages loaded in about 15-20 seconds (and yet I still retained about 30% of the 1,400 members <img> ) and the old topics just didn't load at all. Now it's evident that something is causing them to take longer to load.

Zac

Zac