Mark Breen
marklbreen at gmail.com
Wed Feb 9 10:04:48 CST 2011
Hi Shamil I hope that was useful for you - just to be clear, I was not suggesting it as an alternative to the Google solution you described - in fact I was fascinated by that elegant solution to a search problem. If it is useful to you that will be an added bonus. thanks Mark On 9 February 2011 11:55, Shamil Salakhetdinov <shamil at smsconsulting.spb.ru>wrote: > 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 > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > >