MySQL Forums
Forum List  »  Perl

Re: Problem with timeout issues with mysql code in Perl
Posted by: Randy Clamons
Date: December 11, 2008 11:39AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Re: Problem with timeout issues with mysql code in Perl
December 11, 2008 11:39AM


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.