----- Original Message -----
From: "Mary Anderson" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, March 07, 2006 9:51 PM
Subject: Performance Degradation of ActivePerl CGI script under IIS
Hi All,
I have an 800 line ActivePerl cgi script which I am running under
WindowsXP, IIS on my local machine. It connects to a MySQL database,
which
does not seem to be the problem. I enter data, send it to a review
screen,
then save it to the database. The first few records enter with no problem
- screens come up filled with the information right away. However, as my
session continutes, the performance degrades dramatically. The
application
will switch to the new page, tell me it is fetching data from the local
host, and take a minute or more to complete the screen. I don't know what
is going on -- I don't think it is the time used to interpret the code
because the first few records are processed in a reasonable amount of
time.
IMHO probelem shoud be in MySQL. Check if your sql command use indices or
not. Very interesting may be output from EXPLAIN SELECT ... sql command.
Petr Vileta, Czech republic
(My server reject all messages from Yahoo and Hotmail. Send me your mail
from another non-spammer site please.)
_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
