Mark Breen
marklbreen at gmail.com
Wed Feb 9 04:51:36 CST 2011
Hello Shamil, Off the top of my head, I do not know. But as you probably already know,the DNN forums are very friendly and helpful - I think I always get an answer withing 24 hours. Does it not auto-reindex? I do not know when or how it builds the list of indexes but I would presume that the indexer needs to know when module is "dirty" and then goes ahead and re-indexes it ? Take a look at this table, and perhaps it supports some of my presumptions. CREATE TABLE [dbo].[SearchItem]( [SearchItemID] [int] IDENTITY(1,1) NOT NULL, [Title] [nvarchar](200) NOT NULL, [Description] [nvarchar](2000) NOT NULL, [Author] [int] NULL, [PubDate] [datetime] NOT NULL, [ModuleId] [int] NOT NULL, [SearchKey] [nvarchar](100) NOT NULL, [Guid] [varchar](200) NULL, [HitCount] [int] NULL, [ImageFileId] [int] NULL, Thanks Mark On 9 February 2011 01:08, Shamil Salakhetdinov <shamil at smsconsulting.spb.ru>wrote: > 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 > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > >