Re: Session_OnEnd event doesn't fire
From: Patrick (xxx_at_xxx.xxx)
Date: 04/13/04
- Next message: Lin Ma: "Re: Include file not found???"
- Previous message: Lord Merlin: "sample ASP XP Mail component"
- In reply to: Bob Barrows [MVP]: "Re: Session_OnEnd event doesn't fire"
- Next in thread: Egbert Nierop \(MVP for IIS\): "Re: Session_OnEnd event doesn't fire"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 13 Apr 2004 19:58:17 +0200
thanks Bob
it is the second time you save me :-)
Now; let's code !
"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> a écrit dans le message de
news:%23beW84XIEHA.2524@TK2MSFTNGP11.phx.gbl...
> Patrick wrote:
> >> Yes, have ONE table and have sessionID as a key. Then you can run
> >> queries, delete, etc. where sessionID= instead of dropping and
> >> re-creating tables all day.
> >
> > But because of the page lock, isn't there a risk for a user to lock
> > rows that do not have the same SessionID ?
>
> Yes, since multiple rows will be contained by a single page, and Jet uses
> page-locking, there is a slight possibility of that occurring, especially
if
> you have the table indexed to create a "hot spot" at the last page of the
> table where all new records will be inserted, and you have a lot of users
> attempting simultaneous inserts.
>
> You can minimize the potential impact of these page locks by
> 1. Most important: keep transactions short by using read-only recordsets
for
> data retrieval and INSERT,UPDATE,DELETE queries for data modification.
Also,
> open your connections late (immediately before they are needed) and close
> them early (as soon as you no longer need them)
> 2. If deadlocks are still occurring, use a field (or fields) for your
> primary key that will assure that consecutive session id's will not be
> stored consecutively
> 3. If it is still a problem, pad your records so that each page only
> contains a single row of data. Each page is 2K, so as long as you ensure
> that each row of data contains a little more than 0.9K, you will cause
each
> row to occupy its own page.
>
> With a well-designed application, you should not have to worry about page
> locks impairing user activity unless you are dealing with hundreds of
users.
>
> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>
- Next message: Lin Ma: "Re: Include file not found???"
- Previous message: Lord Merlin: "sample ASP XP Mail component"
- In reply to: Bob Barrows [MVP]: "Re: Session_OnEnd event doesn't fire"
- Next in thread: Egbert Nierop \(MVP for IIS\): "Re: Session_OnEnd event doesn't fire"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
