Developer forum

Hi Manon

Smartsearches on 140.000 users will take some time to execute - it is SQL queries with complex where queries and they will take time to execute.

Dynamicweb supports a lucene index for users that supports queries that can be used in more or less the same way as smart searches. That one performs much better on large solutions because it runs on an index that is made for high performing searches.

Volandis is not hosted in our environement, so cannot look into what is the exact cause. When you have 'complex' databases or uses of them (i.e. a smart search which does a lot of lookup on fields), it is always needs to be optimized with indexes etc. that fulfil the needs. So a bit of DBA work with a profiler and optimisation work should improve the performance.

BR Nicolai

Hi Nicolai, 

We did some imporovement on the index but still when you create a smart search it takes a long time to load. They use this method several times a week, so it is important for them that it works faster. 

In the webinar yesterday you told about customers who have a milion users. How is this going with loading when opening groups or creating smart searches?

BR, 

Manon

Opening groups works fine. Smart searches can be slow - depending on its criterias. Some of these criterias need to look up data in related tables and that can be extensive on wast amounts of data. Switching to the index based searches is the best option.

BR Nicolai