how to improve query performances in lotus notes 4.65?

[d...@gg.com]

our ERP system have is a lotus notes 4.65 application.
the hardware configuration is 2 CPU,256 RAM,30G HardDisk.
there are 50,000 documents in this notes database .
the notes database size is about 50M .
when i open a view to query some reports,
it take 10 minutes to return the query results and display the report.

how to improve notes performances?

any suggestions is appreciated.

thank you very much.

best regards

rockie liu

----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
NewsOne.Net prohibits users from posting spam. If this or other posts
made through NewsOne.Net violate posting guidelines, email ab...@newsone.net

[Lou Moran]

On 2 Mar 2001 16:26:45 GMT, d...@gg.com wrote wonderful things about
sparkplugs:

>
>our ERP system have is a lotus notes 4.65 application.
>the hardware configuration is 2 CPU,256 RAM,30G HardDisk.
>there are 50,000 documents in this notes database .
>the notes database size is about 50M .
>when i open a view to query some reports,
>it take 10 minutes to return the query results and display the report.
>
>how to improve notes performances?

There are lots of places this could be bottlenecking. Some more
obvious hardware spots are:

Network
Harddrive
Virtual Memory
Actual Memory

Viewing all 50,000? docs?

Maybe a Simple Action in the view like If DATEFIELD is BEFORE 01/01/01

stuff like that.

Then get into nutty internals.

--
Member of the Nondeterministic Football League