MySQL painfully slow...

[Arbok9782]

At this point in time, my forums are running painfully slow. Takes about a minute for a topic to fully load, although the site itself (including the parts that use php) work just fine. The forums here as well also appear to be running very sluggish as well. Anyone else noticing this problem, or have any idea what the cause is?

[lucky760]

I've been experiencing the same pain. It's not all my php pages that use mySQL; in fact, it's just one of my pages. Everything loads quickly and normally except one. I've noticed in phpmyadmin on the process list that while the slow page seemingly sits idle as it loads, there is a process that has a command labeled "Sleep" but no query or status (see my thread (http://forum.powweb.com/showthread.php?t=53281)). I have no idea the cause but it's been going on for a few days now... Does this sound like the same thing you're suffering? I wish someone would do something...

[claudiu]

Hi,

I don't know if it is realy a MySQL problem but if it is the maybe try using stored procedures, that might speed up things a little

Clau

[RTH10260]

Hi,

I don't know if it is realy a MySQL problem but if it is the maybe try using stored procedures, that might speed up things a littlHow do you run stored procedures on a MySql v4 installation ?
Stored procedures and functions are a new feature in MySQL version 5.0.Ref: http://dev.mysql.com/doc/mysql/en/stored-procedures.html

PS. the thread you replied to is a week old, the problem has likely been resolved in this time :D