Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Tue Feb 8 19:08:07 CST 2011
Hi Mark -- Thank you for your notes. How to make DNN (re-)indexing a page? There should be special DNN page options to include/exclude a certain page from full text indexing? Thank you. -- Shamil -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Mark Breen Sent: 5 ??????? 2011 ?. 13:43 To: Discussion concerning Visual Basic and related programming issues. Subject: Re: [dba-VB] "Smart" fulltext search on large documents(data)base... 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 > > _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com