By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,837 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,837 IT Pros & Developers. It's quick & easy.

ASP - Access - VBSCript performance

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
On Tue, 09 Sep 2003 20:46:49 GMT in comp.databases.ms-access, Zalek
Bloom <Za********@hotmail.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.
--
A)bort, R)etry, I)nfluence with large hammer.

(replace sithlord with trevor for email)
Nov 12 '05 #2

P: n/a
On Tue, 09 Sep 2003 23:23:58 +0100, Trevor Best <bouncer@localhost>
wrote:
On Tue, 09 Sep 2003 20:46:49 GMT in comp.databases.ms-access, Zalek
Bloom <Za********@hotmail.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.


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

Zalek
Nov 12 '05 #3

P: n/a
Can you post your code? It would make things a little easier.
Random
On Wed, 10 Sep 2003 00:51:07 GMT, Zalek Bloom <Za********@hotmail.com>
wrote:
On Tue, 09 Sep 2003 23:23:58 +0100, Trevor Best <bouncer@localhost>
wrote:
On Tue, 09 Sep 2003 20:46:49 GMT in comp.databases.ms-access, Zalek
Bloom <Za********@hotmail.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.


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

Zalek


Nov 12 '05 #4

P: n/a
On Wed, 10 Sep 2003 00:51:07 GMT in comp.databases.ms-access, Zalek
Bloom <Za********@hotmail.com> wrote:
What is the .ldb file?


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)
Nov 12 '05 #5

P: n/a
On 9 Sep 2003 21:59:06 -0500, Random <Random@nwhere> wrote:
Can you post your code? It would make things a little easier.
Random
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="Microsoft FrontPage 4.0" name="GENERATOR">
</head>

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

Dim DataBase, Recordset, Query

On Error Resume Next

Set DataBase = Server.CreateObject("ADODB.Connection")
DataBase.Open "db1"
Dim SQLst

SQLst = "SELECT * FROM COMPANY"

Set Recordset = DataBase.Execute(SQLst)

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

Dim CompanyName

%>

<script language="VBScript" 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_data.asp">
<input type="hidden" name="company" value=" "><table border="1"
width="100%">
<tr>
<td><%
do until Recordset.EOF
CompanyName = Recordset("CompanyName")
%>
</td>
</tr>
<tr>
<td width="16%"><% =Recordset("CompanyName") %>
</td>
<td width="16%"><input type="button" value="Modify"
onclick="ModCompany('<% =CompanyName %>')"> </td>
<td width="16%"><input type="button" value="Delete"> </td>
</tr>
<% Recordset.MoveNext
loop

DataBase.Close %>

</table>

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

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

Thanks for your help,

Zalek


On Wed, 10 Sep 2003 00:51:07 GMT, Zalek Bloom <Za********@hotmail.com>
wrote:
On Tue, 09 Sep 2003 23:23:58 +0100, Trevor Best <bouncer@localhost>
wrote:
On Tue, 09 Sep 2003 20:46:49 GMT in comp.databases.ms-access, Zalek
Bloom <Za********@hotmail.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.


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

Zalek


Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.