Developer forum

Forum » Development » Search module for DW and custom data

Search module for DW and custom data

E-mail notifications

Reply
Posted on 09/04/2008 09:18:32

This is not exactly a development related issue, but I found this area to suit my question the best.

 

I was wondering if someone have any experience with serachmodules and data from custom modules / databases in Dynamicweb?

 

Preferrably I need a module for Dynamicweb that can handle both searches on pages/paragraphs in default modules but also in custom code/data.

 

Do any of you have any experience (good/bad) with any thing in this area? How do you normally handle searches for the websites you run in Dynamicweb?

 

I can see that DW use Google search for the developer pages here on the site, is this because it is the best alternative to developing something yourself?


Replies

 
Posted on 09/04/2008 10:51:31
Reply

Using the Dynamicweb Developer module you're able to set up Search Weighted to include your custom module content in the default search. Search Weighted the performs a LIKE match in you database according to the settings you make.

 

In many cases this is OK, but if you expect your database to grow very large, and you also perform matches on a number of fields, you'll have to expect some trouble using this appdoach.

If, for instance, you make a match on the imaginary fields Title, Description, and Content, and your database contains 1,000 records, executing the SQL statement must perform 3,000 matches to product the desired result. In addition to that, if your query contains two words, you double the abount of matches that the search has to perform. The statement executed by Search Weighted would look something like:

 

SELECT Title, Description, Content FROM MyTable WHERE (Title LIKE'%Dynamicweb%' OR Title LIKE '%Software%') OR (Description LIKE'%Dynamicweb%' OR Description LIKE '%Software%') OR (Content LIKE'%Dynamicweb%' OR Content LIKE '%Software%')

 

Looks pretty harmless, but trust me, this can be pretty heavy when performing a search.

 

As to the google search, we're using this rather than building our own indexing engine on top of Dynamicweb.

 

You must be logged in to post in the forum