Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Customized search form being slow

Posted on 2002-03-30
Medium Priority
Last Modified: 2013-12-18

Since a while i used customized search form to search my database in the webinterface. The main purpose was to create a complete application , with same look-and-feel all over.
Now i got several complaints about the searches being slow to to display using the customized Search form ( $Search form and $$Return field with the search string ) in comparison with the standard common search form.
I did the test and in fact the first solution is taking a lot of time the first time it was called , new searches after this are faster.
Since the custom search uses a distinct view , i thought that every time the search was called , there was a reindex of the view.
Are there any idead on how to make the custom search at least as fast as the common search ( which uses no distinct vies , afaik )
Question by:Steamer
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
  • +2
LVL 24

Expert Comment

ID: 6908740
Index the database FullText. This will enhance the performance.

Excerpt from notes help
Searching and full-text indexes
Notes searches best on databases with a full-text index. When you create a full-text index, you are scooping up all the text in the database and making a list for Notes to search. This makes the process much faster. When the database is indexed, you also have access to features which allow you to refine or expand your search, and you can get results sorted by how close they are to what you're looking for. In short, indexing the database makes searching quicker and gives you more control.
Without a full-text index, Notes must search a database sequentially -- word by word, document by document. This is slower, and the results are sorted by the order they appear in the view, rather than by how close they are to what you're looking for.

Here is complete documentation on how to Customize search forms,


Author Comment

ID: 6910155
I will check on that , but i think it is Full-Text indexed.
Otherwise i think the common search page would also be slow , which isn't the case apparently.
LVL 24

Accepted Solution

HemanthaKumar earned 400 total points
ID: 6910923
That is right.

In custom form, there is nothing different I believe which can degrade the performance as such. The search is tool related directly to the database and server. So check the link, may be you might be missing some minute details.
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

LVL 10

Expert Comment

ID: 6910973
Hello Steamer,

can you please explain to me what exact the meaning is of "the first time it was called"?

Does it mean: your customized search form needs a lot of time to open for entering the search string?

Or does it mean: search results are returned first time after a longer search period then second search results?

How do you submit second search? Do you have a combo form for search results and next search? Or do you have a button on search results to open your search form again empty or with old search arguments?


Author Comment

ID: 6910991

Heya zvonko :

I meant :
search results are returned first time after a longer search period then second search. The second search is submitted with exactly  the same form ( no changes ) but shortly after the first search.
Also the second searchstring isn't similar to the one used for the first search.

The search form opens again with the old search arguments , which are then being changed to a second searchstring.
LVL 10

Expert Comment

ID: 6911102
what search action do you use in $$Return: ?SearchSite, ?SearchView or ?SearchDomain

Do you have customized search result form? If so, what formulas do you have on search result form beside the $$ViewBody field? Do you use any @DbLookup formulas anywhere on the forms :-)


Expert Comment

ID: 6913671
I experience that same lag on the first search when i use customized search forms. My observation is that after the db is indexed  the first search is always the longest. I still can't figure why but I'm guessing has something to do with the indexing. Maybe after the first search there is somesort of caching or some other mechanism that enables later queries to be done faster.

My search is done a view.

Author Comment

ID: 6913897
zvonko :

I use SearchView with a view just used for websearches. This way i can control how the results show up in the search results place. The search result form is almost only HTML and the $$ViewBody field . It's not complicaterd , just the easiest.
There are no 'dynamic parts' on the search results page , the user can only open one of the returned results.

ruff :
Seems you are experiencing the same thing as i  do
What do you mean by : My search is done a view , is this a  possible solution ?

Expert Comment

ID: 6914789
Hey Steamer,

>> My search is done a view

I was just pointing out that like you I use SearchView with a view to customise my result set.

I have been searching for an answer to this problem for a while now kind of on and off but haven't found anything yet. More and more i think it has something to do with the indexing mechanism that lotus uses.

I have the Db set to index every day and it is only when the first search is done that it takes a long time to display results. After that, everything is nice and fast.

Think this could be a bug?
LVL 10

Expert Comment

ID: 6915137
We got a lot of problems at our servers with wrong setting for this notes.ini variable: FT_LIBNAME

Go to Domino console and enter this command:
show conf FT_LIBNAME

It should not report any value. You do not need this redirection any more.
Our problem was, that we deleted this setting in notes.ini Configuration document, but not noticed that lowercase and uppercase is distinguished in Configuration document setting, so this notes.ini setting did come again and again :-)

LVL 63

Expert Comment

ID: 10840485
No comment has been added to this question in more than 744 days, so it is now classified as abandoned..
I will leave the following recommendation for this question in the Cleanup topic area:

RECOMMENDATION: Award points to HemanthaKumar http:#6908740

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

EE Cleanup Volunteer

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA:…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question