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: nsysdcw at acs dot ncsu dot edu
Subject: Re: cgi perl speed.
Date: Jun 4 1998 12:49PM

You might try the following if it applies to your environmnet:
  Place the Perl distribution on a local drive and disconnect
  as many network drives as possible.  Networked drives tend
  to slow a webserver and as the number of netorked drives
  increases, performance decreases.

  ================================ 
  Don Waterman
  Systems Programmer
  Administrative Computing
  North Carolina State University
  E-Mail  don_waterman@ncsu.edu
  phone  919-513-1167
  fax  919-515-2660
  ================================

> 
> 
> ------ =_NextPart_000_01BD8FA7.57F8B770
> Content-Type: text/plain; charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
> 
> I'd recommend going down to one Sybase engine, and setting the "runnable =
> process search count" to say 8.
> 
> This will make a lot more resource available to other processes.
> 
> As regards the MS6.5, you need to do something similar to reduce the =
> processing it does - there used to be an option in 4.2 days to do the =
> same as "runnable process search count"  which you could check out:-
> 
> in a dos box run:  bldmstr -d -yall
> 
> look in the output for 'cschedspins' - its probably 2000
> 
> change it as follows:-
> 
> bldmstr -d -ycschedspins=3D8
> 
> 
> 
> ________________________________________________________
> 
> Peter Collard=20
> Sybase Database Administrator
> 0171-410-3863
> "The views expressed in this correspondence are mine and not necessarily =
> those of Rabobank International"
> ________________________________________________________
> 
> -----Original Message-----
> >From:	Eric Johanson [SMTP:ERICJ@AMC-DIRECT.COM]
> Sent:	Thursday, June 04, 1998 10:40 AM
> To:	SybPerl Discussion List
> Subject:	cgi perl speed.
> 
> Hello,
> 
> I'm using Syperl to access a sybase sql server... =20
> (BTW, it works great)=20
> 
> 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. =20
> 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.=20
> 
> My question for all of you:   How can I speed this up?=20
> 
> 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!=20
> 
> 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.=20
> 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.  :)  =20
> 
> 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. :)
> 
> ------ =_NextPart_000_01BD8FA7.57F8B770
> Content-Type: application/ms-tnef
> Content-Transfer-Encoding: base64
> 
> eJ8+IjUJAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
> b3NvZnQgTWFpbC5Ob3RlADEIAQmAAQAhAAAAMURFRDQ1QzRFQUZBRDExMUI4RjUwMDgwNUZGNUEx
> OUUAZQcBBYADAA4AAADOBwYABAAKADEALQAEAEsBASCAAwAOAAAAzgcGAAQACgAxAC0ABABLAQEE
> kAYA4AEAAAEAAAARAAAAAwAAMAAAAAALAA8OAAAAAAIB/w8BAAAATQAAAAAAAACBKx+kvqMQGZ1u
> AN0BD1QCAAAAACdTWUJQRVJMLUxAbGlzdHByb2MubmV0JwBTTVRQAFNZQlBFUkwtTEBsaXN0cHJv
> Yy5uZXQAAAAAHgACMAEAAAAFAAAAU01UUAAAAAAeAAMwAQAAABcAAABTWUJQRVJMLUxAbGlzdHBy
> b2MubmV0AAACAfYPAQAAAAQAAAAAAAAAAwAVDAEAAAACAQswAQAAABwAAABTTVRQOlNZQlBFUkwt
> TEBMSVNUUFJPQy5ORVQAHgABMAEAAAAZAAAAJ1NZQlBFUkwtTEBsaXN0cHJvYy5uZXQnAAAAAB4A
> IDoBAAAAGQAAACdTWUJQRVJMLUxAbGlzdHByb2MubmV0JwAAAAALAEA6AQAgcwMA/g8GAAAAAwAA
> OQAAAAADAP9fAAAAAAMA/V8BAAAAHgD2XwEAAAAXAAAAU1lCUEVSTC1MQGxpc3Rwcm9jLm5ldAAA
> AgH3XwEAAABLAAAAAAAAAIErH6S+oxAZnW4A3QEPVAIAAAAAU1lCUEVSTC1MQGxpc3Rwcm9jLm5l
> dABTTVRQAFNZQlBFUkwtTEBsaXN0cHJvYy5uZXQAAIhiAQ2ABAACAAAAAgACAAEEgAEAFAAAAFJF
> OiBjZ2kgcGVybCBzcGVlZC4AVgYBA5AGALAOAAAoAAAAAwA2AAAAAAADAAuACCAGAAAAAADAAAAA
> AAAARgAAAABShQAAdBAAAB4AIIAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABQAAADguMDIA
> AAAAAwAPgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAALAAaACCAGAAAAAADAAAAAAAAARgAA
> AAADhQAAAAAAAAsAJIAIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwAIgAggBgAAAAAAwAAA
> AAAAAEYAAAAAEIUAAAAAAAADACWACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMAJ4AIIAYA
> AAAAAMAAAAAAAABGAAAAABiFAAAAAAAAHgA2gAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAAB
> AAAAAAAAAB4AN4AIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeADiACCAGAAAA
> AADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAAAgEJEAEAAAAqCgAAJgoAAB0QAABMWkZ1ff12
> iAMACgByY3BnMTI1djIA9AH3IAKkA+MCAGOCaArAc2V0MCAHE48CgwBQAvIQGVRhaANxLwKDDlAP
> vxJ5MxM3cHI0cTIQtn0KgAjIIDubCW8OMDUCgAqBdWMAUC0LA2MAQQtgbg4QMDODFQELxCBJJ2Qg
> CXCVBaBtB4BuGuBnbwuAIGcgZG93A6B0b4ogAiBlBgB5YmEQcIogCfBnC4BlLCAAcEsa4BBxdBvC
> dGgcoCLQcnVubgGgbBygFaB8b2MHkAQgEHAKwBAwIBMFoB7QdCIcQnNheTggOC4KogqECoBUaLUE
> ACAD8GwDIADAaxygfGEgCQAFQARgCXAa8XP3CGEfgB2gdgtwC2AfEhxS3x5xBcAfVQeQITtBBCAJ
> cB5nCxEEIB5yBeA2LjX1HZB5CGAgHJAJgBxCHAC/HeADcBCAIhAb0QCQbSRh/wXAHFEJcRjgJLEe
> gR9VG8JuaQVAHAAHkS0eYiNxdVsQcCiTYiLRA6BvBTBppwIgK7ADoDQuFdBkIPD/J1Eowx5yIOAH
> gB2gBCAev78fzSJAIhAgESgiIEFsGuALEDAFkGsccHV0Oi2/IUouESLwHAAEIAbgeBrwDTAQOjHg
> AmBkbXN08QXALWQ8AMA14CUxAQDSdg3gZT4sMHkHQAlQeyFZCQBvM0AuER5yM2FwzTNwIAIQBcAn
> YwTwHoDlJ0BwC4BzJywxK8AEIP8wkRzgAmAhAAHQO6AhShAxfxnQHKArwS/BAhAicBwQc88znDWv
> Nrk52T04IUpBrgcZUgLREWFzMTcgX99D70T/Rg9GUiFKUBCAJTE/CFAicAsRCuMKgBzFRGH7AZEc
> 8kE+0AuABAA/AEngiwWwIUQwQ7AxLTQZ8HAtMzg2FQAhVBMTMco2GaBkAmBxdSMgHKCfIgAcoDbg
> B9AEIGV4FaC/JaIa4DijIiEFoSOhcAIgfQEAbiQCI3FKgS1SGuBu/yMhHJAwwgrAAxAhAB5wNNBd
> OPFmB/ABoDshbjNASf8CMASRSeAt0QdAABBNZkxm/0N/Vo9Xn0avQrUU800hQnlwbGkzNjvBA2A2
> gGP1BUAtXEJPBRAdUQdABdD/UeI80FxDIUZb1DvDCzFb1MECAGktMTQ0AUBbYBwxODuxDNBf42Ig
> RlUDYToMg2IQoEUFEGM4IEpvPKEjwAOgW1MATVRQOkVSSUMASkBBTUMtREkAUkVDVC5DT03+XSFF
> YRAGYAIwYXciAAhwNnMugR2QSjAQHKAwNCEdkDE5OThnEDA6y2AAELBNZJdUb2F3HMHVSCByAyBE
> BABjLMAAkI0t4UxKsWSYdWJqXAH9YXdjHVAwgGlyOjAocSE3n15vX3JbZAu2IVNIZT2B9iwhShrA
> bSyxG8IGsGxzLxxRANAwwyLwcxzUc3HrbKEEkHYEkC50IDHgIUSwKEJUVx2QK8F3BbBuawQgCcFJ
> 4ClI9XDldP4nPUIFwCLwAiBbYByRBbDvBIEpcy6gNoBtHZAecEng/yuwT5EIcAlwAjA7YVtgc/D6
> ISFKVxygEEBz8C0xCfD/G5AeBQORC4AFAB/gHQE4ov9K4AEgDeAdlC8zc9N5YiLA7wUxTZArwFT1
> YizAZmEwAt8eNmx0BQMl4HRWVx6AHJDfftIAcCEAgWk1MnN1EyzB8wQgGfAwJVLCKtkFsHcm3xBw
> BaAbcCFEBbF0dWB0QPciAyIhUXByAMAicCEAUXLfIvA7AjBgePESkHeC8h2QzzIAe/EoInuDNCts
> YS2g/zBhAiAhRC8zf7EdoAVAAiDtJAEofNEKQGQrg1OkAyCzLMBdYS4peQJ+h3M9kX+QgiIxIPEc
> AiE1TfJsci6fTpA84U5xU/Eb0XVwhdg/MICKQQXAW2AiwQUAYXr2eXRAIUpNIQBNkAeQLcOfd0Mi
> cVLRKCE1cSBIHBC7IDADkUlstE9Uk1A/dixaJ3uhTy2xKdB6KIFt74NlBaABAC+ybRjgICAvwf+Y
> YJghHZCAQAVAmGApUjiB/XcCaizABUAecSFEL/Mbwe8gkFLRbHJ5CWFxhJcCHnLvPwAIYDBRdEBB
> g8Z5I4cR/wGQOlEhRCkYL8EpsYwCL8IHFaCOgS/gPGh0bWzkPjwG4GR5NyA2gJZheRvRPC+mZKdA
> pgMv4Dv/L+B5YYxlIrAbwp4jUxE5Ub+b9pQkL8Eeci6ASfVkBRDfc/ADoIG3dvBQ0WemAC0x/6Ou
> LhGbITpRAZBIoS3Dn6VPdEGYYJ4jHABuJwVAa/lRcHchdiuCsAMQgUKL8/9Qok4yqUevQR4gYjAK
> sDzQf4RxfmmC5HwhctEG4HuhMfw1JSFEM3ADEJrQU/MhPW8vUXizeWs1cCgBACJxNJc7kXYQG/B1
> XPFQUANg3CAzO6AdkEwgNCKQJwD/BCBS0UrgePG3ABuQXLAhRP1K4Gka4L2AeKSVJphge4M/TpEd
> sSiBBuAecB5jU1H+TB0lLrMswSLiCsA80Zgg/zMBeQEcYCLAf1BydlLQjGi9jjBzM0AcAz2RdEFB
> nlL/IiFQEI6BHZCYYLEEnXSTUH0JwGGOM35pIlIhRB6AbP+TYE9jjQG7gC3Dg0IjUnRB9jq7QXYr
> UoC1LeEvM7lmyTVxSUkF8DMuEKAx4PkcxTExHZAF4sEhJ9GNwHx5dakwHYGxAyFEHPBr/3UTEEAu
> sy1BLGOPcQZgXWCrSeAcoEIA0GuTUUWSgPViMDchO0mXUxrRlIMcUf8zA6nyKtO04hqxcWCvUakz
> /6nTHZAboHtwLIFhcCFUGXKHMsB7cAJAcDovL5CBUi4vgGMtpPAuGyEvqWwxLWILgC/awS4+8L8j
> YQNRAjBDEzLAO8tPUGL/KCJQojpRvlAqtKaAMDAp0M+0tYVmmCCvUW9neQF1YPeBW1CSPlVlG8KY
> ICJwKIH/A/DAoR/gIBJbYDMwdEDeEPscoDmCTiQwOXC9ISyhydH/LaAdlByCOYIecgDAC4GetPuj
> ImUxInRBiCcecl+wEGD/K9GrnYpQYRCNA5ozOUIcUP98ISUhcHUjwBqz1daxYjHx+3lBN1AnoUOd
> kqnUK8B6i9RPaB2UTTIhYXAwxrH/PREAwJrgnAEqsu6SKDEwkfs24JvBc5wyTpAwwOORpbH3eOAk
> UfOxcFAQACAhRHdEvwNQCeCQ8CNxMJEqgXSwY/8D8SAgI1OL1RBAGuAoIZAxfwkRUsJJ4B4gymAB
> AJF3dfMG0AQgVVB6iyIAU1F3JP+pFaFzB3EqJPixtsHnMpKyv/TCcHViDCxAe1BhEEUdQ/sEkCZl
> ZCRAUGHxMTLA/WK/jjAi8AhQUGHiQixAUgmA5/fgG3AdkFdB59S7AL2AOxhwZ1AzDiEsMXhBY2p+
> QNrCjjAbAfcwGyEhSnD/ghJJwE/xjRLpg3KAorWaM/97080jIiFbYJ5BOYJ/kykD//1TxrGaQefU
> guRQEDZxKJNfK8B0QMuQ59QYoQAOwAAAAwAmAAAAAAADAC4AAAAAAAsAAgABAAAACwAjAAAAAAAL
> ACkAAAAAAB4AcAABAAAAFAAAAFJFOiBjZ2kgcGVybCBzcGVlZC4AAgFxAAEAAAAWAAAAAb2PnvUk
> u/Zq1vuQEdGPtwAAgygKMQAAAwCAEP////8eAEIQAQAAAAEAAAAAAAAAQAA5AIDClxqej70BAwDx
> PwkEAAAeAB4MAQAAAAMAAABFWAAAHgAfDAEAAAA+AAAAL089UkFCT0JBTksgSU5URVJOQVRJT05B
> TC9PVT1MT05ET04vQ049UkVDSVBJRU5UUy9DTj1DT0xMQVJEUAAAAAIB+T8BAAAAWgAAAAAAAADc
> p0DIwEIQGrS5CAArL+GCAQAAAAAAAAAvTz1SQUJPQkFOSyBJTlRFUk5BVElPTkFML09VPUxPTkRP
> Ti9DTj1SRUNJUElFTlRTL0NOPUNPTExBUkRQAAAAHgD4PwEAAAATAAAAQ29sbGFyZCwgUCAoUGV0
> ZXIpAAACAfs/AQAAAFoAAAAAAAAA3KdAyMBCEBq0uQgAKy/hggEAAAAAAAAAL089UkFCT0JBTksg
> SU5URVJOQVRJT05BTC9PVT1MT05ET04vQ049UkVDSVBJRU5UUy9DTj1DT0xMQVJEUAAAAB4A+j8B
> AAAAEwAAAENvbGxhcmQsIFAgKFBldGVyKQAAQAAHMAoShxqej70BQAAIMOhLoRqej70BAwAGEBLR
> 8tEDAAcQuwkAAAMAEBAAAAAAAwAREAAAAAAeAAgQAQAAAGUAAABJRFJFQ09NTUVOREdPSU5HRE9X
> TlRPT05FU1lCQVNFRU5HSU5FLEFORFNFVFRJTkdUSEUiUlVOTkFCTEVQUk9DRVNTU0VBUkNIQ09V
> TlQiVE9TQVk4VEhJU1dJTExNQUtFQUxPAAAAAAMADTT9PwAAAgEUNAEAAAAQAAAAVJShwCl/EBul
> hwgAKyolFx4APQABAAAABQAAAFJFOiAAAAAAHH4=
> 
> ------ =_NextPart_000_01BD8FA7.57F8B770--
> 
>