Mark Breen
marklbreen at gmail.com
Sat Feb 5 04:43:02 CST 2011
Hello Gustav and Shamil Here are a set of tables from DNN SearchCommonWords SearchIndexer SearchIndexer SearchItem SearchItemWord SearchItemWordPosition SearchWord You can almost guess the columns that they include, basically, they seem to create a record for each word in each item and link them back through relational database model. I described it as heavy lifting, as I would have assumed the more abstract ways to achieve this are available. I never used SQL Server Full Text Search but I suppose that is on option. Perhaps the DNN guys can demonstrate their heavy lifting is quick, fast and efficient, but I was rather surprised to see their model. Probably for a portal with 300 - 400 pages, the set of words used is rather narrow and this approach may be useful. I have not look at the code that builds the indexes, but I am imagine it. I was not proposing this as an alternative to Shamil's choice - just mentioned it as it was the same week I saw both options. Mark On 4 February 2011 09:34, Gustav Brock <Gustav at cactus.dk> wrote: > Hi Mark > > What do you mean with ""heavy lifting" way"? Is it ugly or smart or what? > > >>> marklbreen at gmail.com 04-02-2011 10:10 >>> > Hello Shamil > > Just FYI, I happened to look yesterday at the DNN Keyword search tables, > > you may find them interesting also. I was surprised to see such "heavy > lifting" way of providing search. > > Mark > > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > >