PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Rick Smith <rsmith at NAC dot NET>
Subject: Re: cgi perl speed.
Date: Jun 4 1998 12:13PM

you're using perl on NT I imagine ?
Try switching to a scripting package.  We started a site with
perl/NT and had to give up because it was killing the server,
just as you see.  We switched to iHTML (http://www.ihtml.com)
and it's allowed us a LOT more freedom in the things we do
with the server.

On Thu, 4 Jun 1998, Eric Johanson wrote:

> Hello,
> 
> I'm using Syperl to access a sybase sql server...  
> (BTW, it works great) 
> 
> It's for a online ordering system, that is currently live!
> 
> We have been getting an increase in traffic, and the server is kept quite
> busy, running the perl scripts.  
> Whenever any perl script runs, it uses 100% of the processors for a second
> or two. This is normally not a problem, however, when you have 4+ people on
> the site at once (including internal usage.), the server slowwwwws way down.
> The perl.exe is eating up processor power like crazy. 
> 
> My question for all of you:   How can I speed this up? 
> 
> I've Optimized my perl code as much as I can, but I think it's just the
> "running" of perl, that is causing all the trouble. A script that contains
> something as simple as "print " testing   "; " is
> taking just about as much power as the database driven scripts. It might be
> something in my installation of perl.  I just don't know! 
> 
> While people are viewing just static pages, the server never gets above 15%
> utilization.
> 
> The system is currently: (dell 4200)  dual PPro 300, 384 megs of ram, 15 gig
> raid 5 system. 
> I have expanded both the SQL engines to use a large cache, to keep access of
> the disk down low.  At this point, I don't think upgrading the server will
> help this situation any more.  :)   
> 
> Running on the system is:  IIS 3.0   Sybase 11, MS SQL 6.5 (yukie, don't
> ask, it has to be there), Seagate Backup Exec 7.
> 
> If you'd like to checkout the pages I'm talking about, go here:
> http://www.amc-mp.com/cgi-bin/amc.storefront
> 
> Once you are inside the dynamic pages of the catalog, two perl scripts are
> being called with each click. One for Nav frame up top, and one for the main
> "content".   This is the first database driven web site I've put together,
> so I'd like to know what ya'll think about it!
> 
> Oh, and Michael, It amazes me that you provide such excellent email support
> for a freeware product.  I wish more people had your sort of attitude.
> Thumbs UP!
> 
> Thanks for taking the time to read over this email,
> Eric Johanson - Web Engineer
> Advanced Multimedia Concepts - Redmond, WA
> 425 558 3125 - ericj@amc-direct.com
> 
> ps.   Despite the fact that I've been on this list for quite some time, I've
> never posted to it. :)
> 
>