Re: Problem with timeout issues with mysql code in Perl
1. Do you have indexes on username in every table? That would speed up the count process.
2. Are the counts useful to your users, or is that so you can verify that the program is working?
3. What version are you using? Could you do this with a stored procedure?
4. Where in the program is it taking all the time? Getting column information or getting counts?
5. Do you really have username in different cases in different tables?
6. Have you optimised your mySql environment?
7. It never pays to develop db structures in a hurry :) Now you're paying the price. I've done it too many times myself.
Subject
Written By
Posted
December 11, 2008 06:48AM
Re: Problem with timeout issues with mysql code in Perl
December 11, 2008 11:39AM
December 12, 2008 01:43AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.