We have a server running LAMP which contains a number of zencart sites. We noticed a problem when trying to view orders in one of the sites and it timed-out. Now when I do:
"select * from orders"
The whole thing freezes, so does:
Now the orders table should have around 42000 orders in it, do it's not THAT large. Can anyone reccommend any good diagnostic techniques to figure out whats going wrong?