Rick;

I don't think the problems were MySQL; I think it was UBB/PHP was the problem.

Quote
Generated in 5.982 seconds in [color:"blue"] which 0.683 seconds were spent on a total of 14 queries[/color] . Zlib compression


So the query was taking 0.683 seconds but the processing of the results took the other 5.3 seconds.

So the extra ram will (maybe) helping in 2 ways

1, The resultset can be kept in Ram.
2, PHP results / arrays can also be lkept in ram.

Overall good (so far)


F16 - GBR 553 - SOLD

I also talk sport here