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