Re: Apache response time slow

[Oscar Ithier <ithieroscar@xxxxxxxxx>]

The typical response was very fast (on miliseconds).

The access to the database is is part of the connection string on the program.

Apache authenticate the user access to the directories that containts the perl programs, using the httpd.conf and the htgroup and htpasswd file. 

ex.

<Directory /usr/local/apache2/cgi-bin/indocadmin>

AllowOverride None

AuthName "INDOC"

AuthType Basic

AuthUserFile /usr/local/apache2/conf/.htpasswd

AuthGroupFile /usr/local/apache2/conf/.htgroup

<LIMIT GET POST PUT>

require group INDOCSEC

order deny,allow

deny from all

satisfy any

</limit>

</directory>

initialy i get the log message:

    POST HTTP/1.1 401

then is enter user id and password and click enter.

then i get a delay of 40 seconds or more and the log message:

  POST HTTP/1.1 200

indicating OK

No one has changed the Sybase database, i have the only unix workstation, that can telnet to the Database Server.  We are using an intranet classified network.  The Apache, Sybase and the programs are all in the same server.

On Thu, Jun 2, 2016 at 12:51 PM, Mike Rumph <mike.rumph@xxxxxxxxxx> wrote:

On 6/2/2016 9:37 AM, Oscar Ithier wrote:

I am using Apache 2.2.22(Unix), Server port 80, Protocol HTTP/1.0 and Sybase as database.
The Http response time is above 40 seconds, this is to slow for my users.

I don't know when the problem start, but it was fine for the last 5 years.

What can I do to fix the problem.

Hello Oscar,

You can begin by providing more details.
What was the typical response time for the last 5 years?
How is the server configured?
   - Configuration file contents would be helpful here.
   - What MPM is being used?
    - Is Apache httpd being used as a proxy to a Sybase server?
What do you see in the access log?
    - This may help to determine if the delay is in Apache httpd or in the Sybase server?
Has something changed in the Sybase database or in how it is accessed?

Thanks,

Mike


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx
For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx