ASP - Access - VBSCript performance

[Zalek Bloom]

Hello,

I am developing a simple ASP application with VBScript and Access
database. I am testing it on my Win98SE machine using Personal Web
Server. My machine is Celeron 2000 with 512Mb RAM. On the Access I
have 2 tables, each one with less then 20 rows. The problem is, that
each time my application access the database, the response is about 30
second.
My questions:
1. How can I improve response time?
2. Where should I look for a bottle necks?

Thanks,

Zalek

[Trevor Best]

Re: ASP - Access - VBSCript performance

On Tue, 09 Sep 2003 20:46:49 GMT in comp.databases. ms-access, Zalek
Bloom <ZalekBloom@hot mail.com> wrote:
[color=blue]
>Hello,
>
>I am developing a simple ASP application with VBScript and Access
>database. I am testing it on my Win98SE machine using Personal Web
>Server. My machine is Celeron 2000 with 512Mb RAM. On the Access I
>have 2 tables, each one with less then 20 rows. The problem is, that
>each time my application access the database, the response is about 30
>second.
>My questions:
>1. How can I improve response time?
>2. Where should I look for a bottle necks?[/color]

That is slow even for a Celery <g>, do you have the database open in
Access at the time? It may be trying to delete the .ldb file, this can
take time if it's unable to delete it as it retries. I don't know if
the 98 PWS supports connection pooling for database objects, that
should clear the above problem as the server will keep the connection
open to the database for re-use.

If in VInterdev, just step through the server side code.


--
A)bort, R)etry, I)nfluence with large hammer.

(replace sithlord with trevor for email)

[Zalek Bloom]

Re: ASP - Access - VBSCript performance

On Tue, 09 Sep 2003 23:23:58 +0100, Trevor Best <bouncer@localh ost>
wrote:
[color=blue]
>On Tue, 09 Sep 2003 20:46:49 GMT in comp.databases. ms-access, Zalek
>Bloom <ZalekBloom@hot mail.com> wrote:
>[color=green]
>>Hello,
>>
>>I am developing a simple ASP application with VBScript and Access
>>database. I am testing it on my Win98SE machine using Personal Web
>>Server. My machine is Celeron 2000 with 512Mb RAM. On the Access I
>>have 2 tables, each one with less then 20 rows. The problem is, that
>>each time my application access the database, the response is about 30
>>second.
>>My questions:
>>1. How can I improve response time?
>>2. Where should I look for a bottle necks?[/color]
>
>That is slow even for a Celery <g>, do you have the database open in
>Access at the time? It may be trying to delete the .ldb file, this can
>take time if it's unable to delete it as it retries. I don't know if
>the 98 PWS supports connection pooling for database objects, that
>should clear the above problem as the server will keep the connection
>open to the database for re-use.
>
>If in VInterdev, just step through the server side code.[/color]

No, I don't have Access open.
What is the .ldb file?

Zalek

[Random]

Re: ASP - Access - VBSCript performance

Can you post your code? It would make things a little easier.


Random


On Wed, 10 Sep 2003 00:51:07 GMT, Zalek Bloom <ZalekBloom@hot mail.com>
wrote:
[color=blue]
>On Tue, 09 Sep 2003 23:23:58 +0100, Trevor Best <bouncer@localh ost>
>wrote:
>[color=green]
>>On Tue, 09 Sep 2003 20:46:49 GMT in comp.databases. ms-access, Zalek
>>Bloom <ZalekBloom@hot mail.com> wrote:
>>[color=darkred]
>>>Hello,
>>>
>>>I am developing a simple ASP application with VBScript and Access
>>>database. I am testing it on my Win98SE machine using Personal Web
>>>Server. My machine is Celeron 2000 with 512Mb RAM. On the Access I
>>>have 2 tables, each one with less then 20 rows. The problem is, that
>>>each time my application access the database, the response is about 30
>>>second.
>>>My questions:
>>>1. How can I improve response time?
>>>2. Where should I look for a bottle necks?[/color]
>>
>>That is slow even for a Celery <g>, do you have the database open in
>>Access at the time? It may be trying to delete the .ldb file, this can
>>take time if it's unable to delete it as it retries. I don't know if
>>the 98 PWS supports connection pooling for database objects, that
>>should clear the above problem as the server will keep the connection
>>open to the database for re-use.
>>
>>If in VInterdev, just step through the server side code.[/color]
>
>No, I don't have Access open.
>What is the .ldb file?
>
>Zalek[/color]

[Trevor Best]

Re: ASP - Access - VBSCript performance

On Wed, 10 Sep 2003 00:51:07 GMT in comp.databases. ms-access, Zalek
Bloom <ZalekBloom@hot mail.com> wrote:
[color=blue]
>What is the .ldb file?[/color]

It's the locking file created when you open the .MDB, first one in
creates it, last one out deletes it. Unfortunately everyone closing
the database will attempt to delete it, if that delete fails it
re-tries, about 15 times, this can cause a delay of a couple of
seconds or so.

--
A)bort, R)etry, I)nfluence with large hammer.

(replace sithlord with trevor for email)

[Zalek Bloom]

Re: ASP - Access - VBSCript performance

On 9 Sep 2003 21:59:06 -0500, Random <Random@nwher e> wrote:
[color=blue]
>Can you post your code? It would make things a little easier.
>
>
>Random[/color]

Random,

I created a few ASP pages and the response from all pages is more or
less the same - about 20 - 30 sec. This is not a real application, I
just learn to read/update Access file using SQL.
Here is example of one page (I removed non relevant code):

<% Option Explicit %>
<% Response.Buffer = true %>
<html>

<head>
<title>Show all Companies</title>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta content="Micros oft FrontPage 4.0" name="GENERATOR ">
</head>

<body>
<div align="left"><%
Dim Name, LegalName, Address1,Addres s2, City, Zip, State, Phone,
Email, Fax, URL, Error_message
Error_message = ""

Dim DataBase, Recordset, Query

On Error Resume Next

Set DataBase = Server.CreateOb ject("ADODB.Con nection")
DataBase.Open "db1"
Dim SQLst

SQLst = "SELECT * FROM COMPANY"

Set Recordset = DataBase.Execut e(SQLst)

IF Err.Number <> 0 then
Error_message = "***** Error - SQL didnt work *****"
end if

Dim CompanyName

%>

<script language="VBScr ipt" type="text/vbscript"><!--
function ModCompany(a)
document.form1. company.value = a
document.form1. submit()
End Function

-->
</script>

</p>

<form name="Form1" method="post"
action="http://localhost/testasp/show_company_da ta.asp">
<input type="hidden" name="company" value=" "><table border="1"
width="100%">
<tr>
<td><%
do until Recordset.EOF
CompanyName = Recordset("Comp anyName")
%>
</td>
</tr>
<tr>
<td width="16%"><% =Recordset("Com panyName") %>
</td>
<td width="16%"><in put type="button" value="Modify"
onclick="ModCom pany('<% =CompanyName %>')"> </td>
<td width="16%"><in put type="button" value="Delete"> </td>
</tr>
<% Recordset.MoveN ext
loop

DataBase.Close %>

</table>

<!--webbot bot="HTMLMarkup " startspan TAG="XBOT" --><!--webbot
bot="HTMLMarkup " endspan
-->

</form>
</div>
</body>
</html>

Thanks for your help,

Zalek
[color=blue]
>
>
>On Wed, 10 Sep 2003 00:51:07 GMT, Zalek Bloom <ZalekBloom@hot mail.com>
>wrote:
>[color=green]
>>On Tue, 09 Sep 2003 23:23:58 +0100, Trevor Best <bouncer@localh ost>
>>wrote:
>>[color=darkred]
>>>On Tue, 09 Sep 2003 20:46:49 GMT in comp.databases. ms-access, Zalek
>>>Bloom <ZalekBloom@hot mail.com> wrote:
>>>
>>>>Hello,
>>>>
>>>>I am developing a simple ASP application with VBScript and Access
>>>>database. I am testing it on my Win98SE machine using Personal Web
>>>>Server. My machine is Celeron 2000 with 512Mb RAM. On the Access I
>>>>have 2 tables, each one with less then 20 rows. The problem is, that
>>>>each time my application access the database, the response is about 30
>>>>second.
>>>>My questions:
>>>>1. How can I improve response time?
>>>>2. Where should I look for a bottle necks?
>>>
>>>That is slow even for a Celery <g>, do you have the database open in
>>>Access at the time? It may be trying to delete the .ldb file, this can
>>>take time if it's unable to delete it as it retries. I don't know if
>>>the 98 PWS supports connection pooling for database objects, that
>>>should clear the above problem as the server will keep the connection
>>>open to the database for re-use.
>>>
>>>If in VInterdev, just step through the server side code.[/color]
>>
>>No, I don't have Access open.
>>What is the .ldb file?
>>
>>Zalek[/color][/color]