Agent performance issue

Hello,

I have a performance issue with lotus agent. All I am doing with this agent is whenever user logs in on web, I update date field with current date. This agent called from a form in WEBQueryOpen Event within one of the frame, and I have arround 10,000 Users who logs in to my applicaiton via authentication. It works fine the way what it suppose to do but, it

really slows down the server, some time even crashing the server. Users complaining that application is locked, coming up very slow, etc.

Sub Initialize

Dim doc1 As NotesDocument	

Dim session As New NotesSession

Dim db As NotesDatabase

Dim view As NotesView

Dim doc As NotesDocument		



Set doc1 = session.DocumentContext

Dim user As String

user = doc1.Username(0)

Set db = session.GetDatabase("", "db1.nsf")		

Set view = db.GetView ("(Lookup)" )

Set doc = view.GetDocumentByKey (user )

If Not (doc Is Nothing) Then

	Call doc.ReplaceItemValue ( "LogDate", Today() )		

	Call doc.Save( False, True )

End If

End Sub

Any other approach that I can think of to make it work smoothly.

Thanks

MS

Subject: Agent performance issue

This article from Agent FAQ (see Resources on the right) might be helpful:IBM - United States