Facing this problem only since the last week.
If debugged through the client, the script debugger, and hence Notes Client hangs when i get to the db.search line. i checked the query passed and that seems fine(given below). the database is 50MB in size.
If i run the same piece of code on the browser, it hangs http as well…and i need to restart the server at times.
In addition to the above, what would you consider to be a more optimal solution to get a collection of documents from the database having a particular criteria (viz: created between two dates).
Query = “@UpperCase(form) = ““FRMSR”” & @UpperCase(RequestType) = ““CDR”” & @date(@created) >= @date(@texttonumber(@word(”“”+strsdate+“”“;”“/”“;3));@texttonumber(@word(”“”+strsdate+“”“;”“/”“;2));@texttonumber(@word(”“”+strsdate+“”“;”“/”“;1)))”+" & @date(@created) <= @date(@texttonumber(@word(“”“+stredate+”“”;“”/“”;3));@texttonumber(@word(“”“+stredate+”“”;“”/“”;2));@texttonumber(@word(“”“+stredate+”“”;“”/“”;1)))"
strsdate and stredate are strings in the dd/mm/yyyy format.