Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Wed Feb 9 05:55:55 CST 2011
Hi Mark -- I have checked my test web site - full text indexing seems to be done not instantly for large texts of HTML modules but it's somehow delayed: it works now for the html module, which it didn't work for when I first saved that module's large text. Yes, I will try to ask about HTML modules' text indexing on DNN... 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: 9 ??????? 2011 ?. 13:52 To: Discussion concerning Visual Basic and related programming issues. Subject: Re: [dba-VB] "Smart" fulltext search on large documents(data)base... 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 > > _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com