Slow MDB acess in global.asa

[Paul Close]

Hi Everyone,

The following code runs in less than one second when used in an ASP page but
when used in Session_onStart() in global.asa, the first page in a new
session is delayed by more than thirty seconds. The code seems to work - its
just slooow. Why is this so and how do I fix it?

Dim cnComDoc
Set cnComDoc = Server.CreateObject("ADODB.Connection")
cnComDoc.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\comdoc.mdb;Persist Security Info=False"
cnComDoc.execute "Insert into SessionInfo
(SessionID,BeginDateTime,IPAddress) values ('" & Session.SessionID & "','" &
FormatDateTime(now(), vbGeneralDate) & "','" &
Request.ServerVariables("REMOTE_ADDR") & "')",,adCmdText +
adExecuteNoRecords
Set cnComDoc = Nothing

[Paul Close]

Hi Everyone,

The following code runs in less than one second when used in an ASP page but
when used in Session_onStart() in global.asa, the first page in a new
session is delayed by more than thirty seconds. The code seems to work - its
just slooow. Why is this so and how do I fix it?

Dim cnComDoc
Set cnComDoc = Server.CreateObject("ADODB.Connection")
cnComDoc.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\comdoc.mdb;Persist Security Info=False"
cnComDoc.execute "Insert into SessionInfo
(SessionID,BeginDateTime,IPAddress) values ('" & Session.SessionID & "','" &
FormatDateTime(now(), vbGeneralDate) & "','" &
Request.ServerVariables("REMOTE_ADDR") & "')",,adCmdText +
adExecuteNoRecords
Set cnComDoc = Nothing

[Phillip Windell]

You fix it by not doing it in the Global.asa file. You're supposed to
do it in the ASP file that needs it (use an Include file).


--

Phillip Windell [CCNA, MVP, MCP]
[email]pwindell@wandtv.com[/email]
WAND-TV (ABC Affiliate)
[url]www.wandtv.com[/url]

"Paul Close" <support@computerdoctor.com.au> wrote in message
news:eEih4KhhDHA.2436@tk2msftngp13.phx.gbl...

> Hi Everyone,
>
> The following code runs in less than one second when used in an ASP

page but

> when used in Session_onStart() in global.asa, the first page in a

new

> session is delayed by more than thirty seconds. The code seems to

work - its

> just slooow. Why is this so and how do I fix it?
>
> Dim cnComDoc
> Set cnComDoc = Server.CreateObject("ADODB.Connection")
> cnComDoc.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=c:\comdoc.mdb;Persist Security Info=False"
> cnComDoc.execute "Insert into SessionInfo
> (SessionID,BeginDateTime,IPAddress) values ('" & Session.SessionID &

"','" &

> FormatDateTime(now(), vbGeneralDate) & "','" &
> Request.ServerVariables("REMOTE_ADDR") & "')",,adCmdText +
> adExecuteNoRecords
> Set cnComDoc = Nothing
>
>

[Phillip Windell]

You fix it by not doing it in the Global.asa file. You're supposed to
do it in the ASP file that needs it (use an Include file).


--

Phillip Windell [CCNA, MVP, MCP]
[email]pwindell@wandtv.com[/email]
WAND-TV (ABC Affiliate)
[url]www.wandtv.com[/url]

"Paul Close" <support@computerdoctor.com.au> wrote in message
news:eEih4KhhDHA.2436@tk2msftngp13.phx.gbl...

> Hi Everyone,
>
> The following code runs in less than one second when used in an ASP

page but

> when used in Session_onStart() in global.asa, the first page in a

new

> session is delayed by more than thirty seconds. The code seems to

work - its

> just slooow. Why is this so and how do I fix it?
>
> Dim cnComDoc
> Set cnComDoc = Server.CreateObject("ADODB.Connection")
> cnComDoc.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=c:\comdoc.mdb;Persist Security Info=False"
> cnComDoc.execute "Insert into SessionInfo
> (SessionID,BeginDateTime,IPAddress) values ('" & Session.SessionID &

"','" &

> FormatDateTime(now(), vbGeneralDate) & "','" &
> Request.ServerVariables("REMOTE_ADDR") & "')",,adCmdText +
> adExecuteNoRecords
> Set cnComDoc = Nothing
>
>

[Phillip Windell]

Sorry, I should have added more. Yes the Global.asa would seem to be
the logical place to do this, but from what I've seen it doesn't
always work that well. I assume you are wanting to track a user to see
how long they were there or estimate when they left the site.
If you're wanting to store the Session ID, then you'd want to make
sure that the Session ID doesn't already exist before adding the
record so it doesn't add a duplicate record each time they move to
another page. You probably would want some kind of timestamp that is
updated with each page they go to and then if the timestamp becomes
older than the site's Session Timeout then either delete the record or
do some other action based on that.

--

Phillip Windell [CCNA, MVP, MCP]
[email]pwindell@wandtv.com[/email]
WAND-TV (ABC Affiliate)
[url]www.wandtv.com[/url]

"Paul Close" <support@computerdoctor.com.au> wrote in message
news:eEih4KhhDHA.2436@tk2msftngp13.phx.gbl...

> Hi Everyone,
>
> The following code runs in less than one second when used in an ASP

page but

> when used in Session_onStart() in global.asa, the first page in a

new

> session is delayed by more than thirty seconds. The code seems to

work - its

> just slooow. Why is this so and how do I fix it?
>
> Dim cnComDoc
> Set cnComDoc = Server.CreateObject("ADODB.Connection")
> cnComDoc.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=c:\comdoc.mdb;Persist Security Info=False"
> cnComDoc.execute "Insert into SessionInfo
> (SessionID,BeginDateTime,IPAddress) values ('" & Session.SessionID &

"','" &

> FormatDateTime(now(), vbGeneralDate) & "','" &
> Request.ServerVariables("REMOTE_ADDR") & "')",,adCmdText +
> adExecuteNoRecords
> Set cnComDoc = Nothing
>
>

[Phillip Windell]

Sorry, I should have added more. Yes the Global.asa would seem to be
the logical place to do this, but from what I've seen it doesn't
always work that well. I assume you are wanting to track a user to see
how long they were there or estimate when they left the site.
If you're wanting to store the Session ID, then you'd want to make
sure that the Session ID doesn't already exist before adding the
record so it doesn't add a duplicate record each time they move to
another page. You probably would want some kind of timestamp that is
updated with each page they go to and then if the timestamp becomes
older than the site's Session Timeout then either delete the record or
do some other action based on that.

--

Phillip Windell [CCNA, MVP, MCP]
[email]pwindell@wandtv.com[/email]
WAND-TV (ABC Affiliate)
[url]www.wandtv.com[/url]

"Paul Close" <support@computerdoctor.com.au> wrote in message
news:eEih4KhhDHA.2436@tk2msftngp13.phx.gbl...

> Hi Everyone,
>
> The following code runs in less than one second when used in an ASP

page but

> when used in Session_onStart() in global.asa, the first page in a

new

> session is delayed by more than thirty seconds. The code seems to

work - its

> just slooow. Why is this so and how do I fix it?
>
> Dim cnComDoc
> Set cnComDoc = Server.CreateObject("ADODB.Connection")
> cnComDoc.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=c:\comdoc.mdb;Persist Security Info=False"
> cnComDoc.execute "Insert into SessionInfo
> (SessionID,BeginDateTime,IPAddress) values ('" & Session.SessionID &

"','" &

> FormatDateTime(now(), vbGeneralDate) & "','" &
> Request.ServerVariables("REMOTE_ADDR") & "')",,adCmdText +
> adExecuteNoRecords
> Set cnComDoc = Nothing
>
>

[Arnold Shore]

Good advice, I guess; I've been fighting that symptom. But where does it
say that "You're supposed to do it in the ASP file that needs it"

AS

"Phillip Windell" <pwindell{at}wandtv*d0t*com> wrote in message
news:#8xmRAphDHA.2500@TK2MSFTNGP09.phx.gbl...

> You fix it by not doing it in the Global.asa file. You're supposed to
> do it in the ASP file that needs it (use an Include file).
>
>
> --
>
> Phillip Windell [CCNA, MVP, MCP]
> [email]pwindell@wandtv.com[/email]
> WAND-TV (ABC Affiliate)
> [url]www.wandtv.com[/url]
>
> "Paul Close" <support@computerdoctor.com.au> wrote in message
> news:eEih4KhhDHA.2436@tk2msftngp13.phx.gbl...

> > Hi Everyone,
> >
> > The following code runs in less than one second when used in an ASP

> page but

> > when used in Session_onStart() in global.asa, the first page in a

> new

> > session is delayed by more than thirty seconds. The code seems to

> work - its

> > just slooow. Why is this so and how do I fix it?
> >
> > Dim cnComDoc
> > Set cnComDoc = Server.CreateObject("ADODB.Connection")
> > cnComDoc.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > Source=c:\comdoc.mdb;Persist Security Info=False"
> > cnComDoc.execute "Insert into SessionInfo
> > (SessionID,BeginDateTime,IPAddress) values ('" & Session.SessionID &

> "','" &

> > FormatDateTime(now(), vbGeneralDate) & "','" &
> > Request.ServerVariables("REMOTE_ADDR") & "')",,adCmdText +
> > adExecuteNoRecords
> > Set cnComDoc = Nothing
> >
> >

>
>

[Arnold Shore]

Good advice, I guess; I've been fighting that symptom. But where does it
say that "You're supposed to do it in the ASP file that needs it"

AS

"Phillip Windell" <pwindell{at}wandtv*d0t*com> wrote in message
news:#8xmRAphDHA.2500@TK2MSFTNGP09.phx.gbl...

> You fix it by not doing it in the Global.asa file. You're supposed to
> do it in the ASP file that needs it (use an Include file).
>
>
> --
>
> Phillip Windell [CCNA, MVP, MCP]
> [email]pwindell@wandtv.com[/email]
> WAND-TV (ABC Affiliate)
> [url]www.wandtv.com[/url]
>
> "Paul Close" <support@computerdoctor.com.au> wrote in message
> news:eEih4KhhDHA.2436@tk2msftngp13.phx.gbl...

> > Hi Everyone,
> >
> > The following code runs in less than one second when used in an ASP

> page but

> > when used in Session_onStart() in global.asa, the first page in a

> new

> > session is delayed by more than thirty seconds. The code seems to

> work - its

> > just slooow. Why is this so and how do I fix it?
> >
> > Dim cnComDoc
> > Set cnComDoc = Server.CreateObject("ADODB.Connection")
> > cnComDoc.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > Source=c:\comdoc.mdb;Persist Security Info=False"
> > cnComDoc.execute "Insert into SessionInfo
> > (SessionID,BeginDateTime,IPAddress) values ('" & Session.SessionID &

> "','" &

> > FormatDateTime(now(), vbGeneralDate) & "','" &
> > Request.ServerVariables("REMOTE_ADDR") & "')",,adCmdText +
> > adExecuteNoRecords
> > Set cnComDoc = Nothing
> >
> >

>
>

[Phillip Windell]

"Arnold Shore" <ashore@saefern.org> wrote in message
news:e1Nza$shDHA.2420@TK2MSFTNGP10.phx.gbl...

> Good advice, I guess; I've been fighting that symptom. But where

does it

> say that "You're supposed to do it in the ASP file that needs it"

It's the "proverbial it", kinda like the "proverbial they".

It is just the normal principle of only creating what you need when
you need it, then use it, then close or eliminate it as soon as your
finished, rather than do it in the global.asa where it continues to
exist throught the life of the Application.

Plus using it in Include files means if a page doesn't require any
database activity, then the particular Include file isn't used,
therefore no resources are used for a database connection that you
don't need. In other words,...treat each page as its own individual
stand-alone program except for specific situations that require
otherwise. That is the concept that HTTP is built on anyway.

--

Phillip Windell [CCNA, MVP, MCP]
[email]pwindell@wandtv.com[/email]
WAND-TV (ABC Affiliate)
[url]www.wandtv.com[/url]

[Phillip Windell]

"Arnold Shore" <ashore@saefern.org> wrote in message
news:e1Nza$shDHA.2420@TK2MSFTNGP10.phx.gbl...

> Good advice, I guess; I've been fighting that symptom. But where

does it

> say that "You're supposed to do it in the ASP file that needs it"

It's the "proverbial it", kinda like the "proverbial they".

It is just the normal principle of only creating what you need when
you need it, then use it, then close or eliminate it as soon as your
finished, rather than do it in the global.asa where it continues to
exist throught the life of the Application.

Plus using it in Include files means if a page doesn't require any
database activity, then the particular Include file isn't used,
therefore no resources are used for a database connection that you
don't need. In other words,...treat each page as its own individual
stand-alone program except for specific situations that require
otherwise. That is the concept that HTTP is built on anyway.

--

Phillip Windell [CCNA, MVP, MCP]
[email]pwindell@wandtv.com[/email]
WAND-TV (ABC Affiliate)
[url]www.wandtv.com[/url]