Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
I'm working on a large CGI application(when done will be around 6000 lines, not huge, but big enough). It accesses multiple MySQl databases and uses and object oriented design to run backends to access these databases. It also does file output operations, one run could do around 400 files running 400+ sql queries to retrieve information. I was curious if anyone had ideas so speed up the code. It's about three seconds, but...phew...thats too slow. It needs to be fast __WITHOUT__ MOD_PERL :). I'm already using strict, warning, and several other security options. I'm considering using goto to optimize once we're done coding...but I'd REALLY like to avoid it, even though I realize sometimes it's the fastes way to get things done. If anyone has any ideas I'd be greatful.
"Thou shalt not follow the null pointer, for chaos and danger lie at its end!"
--C++ Commandments, 1st commandment