I am having problems deleting links; it takes forever. I wanted to delete 11,000 plus links and I can only delete 25 links at a time and then it still takes between 2 and 5 minutes for the program to delete them. I restarted MySql just incase and that did not fix the problem.
Is there a way to delete numerous links without taking a week to delete them?
When I try to delete more than 25 links at a time apache times out. So I called my server tech support and this is what they found. (my notes hope they make sense.)
MySQL keeps hanging up. The program is not closing during certain transaction, apparently the program is looping. Its keeping things open within a month the program requires that I shut down mySQL and restart it to stop the program from running continuously.
MySQL process is hanging generates a statement that is either (cartesian product) - instead of getting records that match criteria, that it multiplies everything.
Hick up or bug causing the program to hang. Server starts reaching a hide load, the MySql can be recompiled.
Sandra Roussel
Chonsa Group Design - Fresh Start Housing
Is there a way to delete numerous links without taking a week to delete them?
When I try to delete more than 25 links at a time apache times out. So I called my server tech support and this is what they found. (my notes hope they make sense.)
MySQL keeps hanging up. The program is not closing during certain transaction, apparently the program is looping. Its keeping things open within a month the program requires that I shut down mySQL and restart it to stop the program from running continuously.
MySQL process is hanging generates a statement that is either (cartesian product) - instead of getting records that match criteria, that it multiplies everything.
Hick up or bug causing the program to hang. Server starts reaching a hide load, the MySql can be recompiled.
Sandra Roussel
Chonsa Group Design - Fresh Start Housing