Hi All,I have a strange problem. The users and the servers were recently migrated to R6 for Mac. Everyting worked fine before that. But recently the code in an action button has started giving problems. The action has code to search and update a document depending upon the changes made to the form. When the users click this button the action seems to go on and on and on … with no result.
I debugged using the debugger and found that the code is stuck up at the line containg NotesDatabase.Search i.e. the search goes on and on and on.
Is it an index problem ?? i created an index for the database using the database properties. I still get stuck at the same place. Is it something else that i shuld be doing ?? will and updall action help ?? please do help. my users have started giving me a hard time.
Thanx in advance,
Rashmi
Subject: NotesDatabase.Search
NotesDocument.Search does tend to be slow because it has to look at each document, and a full text index does not help.
I don’t know any reason it should be significantly slower on Macs, unless the particular machines are just slower than the previous workstations.
If it’s possible to write your search expression as a full text search and use FTSearch instead, you would definitely get better performance from that, provided the database is full text indexed.
Subject: NotesDatabase.Search
I have seen similar behavior using the Search method on R6. If you wait long enough, I found it takes about 430 seconds to return the document collection. Clearly it’s some sort of configuration problem because it didn’t take 430 seconds a couple of weeks ago. I noticed the change when I started filtering my collection with different dates.
I have the same code on a different machine hitting the same database and the same search takes less than 10 seconds. I know I’m not really helping you out but it’s always nice to know that someone else has the same problem.