Database Size, Effects Preformance

[Steve123]

Hey Guys and Gals,

I am in the process of updateing my 850MB+ database from vb2 to vb3..

I decied i wanted to preform a little test, to see how much a larger database effects the index.php load time.

I coped the database to my test server (nothing on it). I striped the database of its attachment database (560MB) and a few posts. I got it down to 20MB in size. Converted to vb3.

I made another copy of the database but time this time i left it as 850MB in size and converted it to vb3.

On the 20MB Database the index.php loads in 0.15160990

On the 850MB Database the index.php loads in 2.94533896

Now the thing i dont understand is there is the exact same amount of users on each database etc.. Why is the loading so different, the only thing i stripped was the posts im sure. The index.php hardly touches the posts table.

I am giong to do futher testing to find out exactly what is causing it to take longer to load, but in the meantime can anyone give me any hints before i sit down going throught everything one by one :P

Thanks
Steve

[Steve123]

Ahh.. i see now..

It does 1-2 queries on the post table which takes 1second..


Nevermind..