Hi, I hope at some point I can do that. I am not sure I will get the boss's permission to do something that official. Right now we are running along with no problems. I did find that I had not been using connect_on_init in my start.pl re Apache::DBI stuff. I don't really understand why I end up with one connection *total* without that line. But when I use it I get the expected one connection per Apache server process. I can say that we have a website that does many gigs of traffic every day, running on CGI (I want to switch to mod_perl but can't yet) The forms all use a CGI::Application module and we have several instance scripts including one that sets the charset for some Japaneese templates. We also have a customer service system that uses mysql replication to get orders from the website's db server, that is also based on CGI::Application, HTML::Template and mod_perl. That is a whole ton of code and modules, all made managable thanks to some OOP and thanks to CGI::App and HTML::Template. And we have yet another CGI::App module that deals with Call Center data entry. While I still have lots to learn about how to take advantage of these tools, we have been able to gain a great deal in building a pretty large system with them. Thanks, Eric At 10:26 AM 10/7/02 -0400, William McKee wrote: >Hello Eric, > >You ought to write a success story for perl.apache.org in your spare time! >It'd be great to have a CGI::App example. > >I'm not yet familiar enough with mod_perl and Apache::DBI to offer much in >the way of advice. However, I can say that I have not had any problems >with my db connections so far. Personally, I would suspect timeout errors >may be a problem with that remote db. Are your db failures usu. the remote >db or the local db? Have you done any stress-testing of the remote db >server from the local server? I believe there are some sample scripts at >perl.apache.org that you could modify. > >Good luck, >William > >-- > Lead Developer > Knowmad Services Inc. || Internet Applications & Database Integration > http://www.knowmad.com > > > >--------------------------------------------------------------------- >Web Archive: http://www.mail-archive.com/suppressed/ >To unsubscribe, e-mail: suppressed >For additional commands, e-mail: suppressed > http://www.kwinternet.com/eric (250) 655 - 9513 (PST Time Zone) "Inquiry is fatal to certainty." -- Will Durant --------------------------------------------------------------------- Web Archive: http://www.mail-archive.com/suppressed/ To unsubscribe, e-mail: suppressed For additional commands, e-mail: suppressed
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.