Re: Multi Lingual Full Text Index rebuild consumes lot of memory
From: <prasad.epal_at_gmail.com>
Date: Mon, 23 Feb 2009 06:22:38 -0800 (PST)
Message-ID: <75f8a235-5930-4568-bf8a-c05238c9b36b_at_f33g2000vbf.googlegroups.com>
On Feb 4, 2:59 pm, Shakespeare <what..._at_xs4all.nl> wrote:
> prasad.e..._at_gmail.com schreef:
>
>
>
>
>
> > On Jan 31, 7:44 pm, Shakespeare <what..._at_xs4all.nl> wrote:
> >> prasad.e..._at_gmail.com schreef:
>
> >>> Hi All,
> >>> We have amultilingualfulltextindexwhere in lexers for specific
> >>> languages can be added any time depenedin upon the reuirement.
> >>> So whenever there is a new lexer added we add the new lexer to the
> >>> multilexer and rebuild theindex.
> >>> During rebuilding theindex, oracle is consuming lot of memory. I
> >>> already tried using memory parameter but not of much use.
> >>> Any Suggestions or comments Please.
> >> Be glad Oracle consumes a lot of memory! Would be worse if you stuffed
> >> your server with memory and no process used it.....
> >> So what is the actual problem? How many times do you have to add a lexer?
>
> >> Shakespeare
>
> > Whenever we add a new language to the application we use there will be
> > documents created in that language..so to handle search in other
> > languages we rebuild theindexafter adding a lexer for that
> > language..
>
> > When we add the lexer and while rebuilding theindexit consumes
> > time...ofcourse there would be around 2500 documents to be indexed...
>
> So the question transformed to: How many times do you add a new language?
>
> Shakespeare- Hide quotedtext-
>
> - Show quotedtext-
Date: Mon, 23 Feb 2009 06:22:38 -0800 (PST)
Message-ID: <75f8a235-5930-4568-bf8a-c05238c9b36b_at_f33g2000vbf.googlegroups.com>
On Feb 4, 2:59 pm, Shakespeare <what..._at_xs4all.nl> wrote:
> prasad.e..._at_gmail.com schreef:
>
>
>
>
>
> > On Jan 31, 7:44 pm, Shakespeare <what..._at_xs4all.nl> wrote:
> >> prasad.e..._at_gmail.com schreef:
>
> >>> Hi All,
> >>> We have amultilingualfulltextindexwhere in lexers for specific
> >>> languages can be added any time depenedin upon the reuirement.
> >>> So whenever there is a new lexer added we add the new lexer to the
> >>> multilexer and rebuild theindex.
> >>> During rebuilding theindex, oracle is consuming lot of memory. I
> >>> already tried using memory parameter but not of much use.
> >>> Any Suggestions or comments Please.
> >> Be glad Oracle consumes a lot of memory! Would be worse if you stuffed
> >> your server with memory and no process used it.....
> >> So what is the actual problem? How many times do you have to add a lexer?
>
> >> Shakespeare
>
> > Whenever we add a new language to the application we use there will be
> > documents created in that language..so to handle search in other
> > languages we rebuild theindexafter adding a lexer for that
> > language..
>
> > When we add the lexer and while rebuilding theindexit consumes
> > time...ofcourse there would be around 2500 documents to be indexed...
>
> So the question transformed to: How many times do you add a new language?
>
> Shakespeare- Hide quotedtext-
>
> - Show quotedtext-
We add a new language only once. We add new languages based on the requirement if we would like to support the new language. So is there a way to control the memory usage while rebuilding the index? Received on Mon Feb 23 2009 - 08:22:38 CST