"EP" <[EMAIL PROTECTED]> wrote on 15/12/2004 15:44:15:
> Thomas Spahni <[EMAIL PROTECTED]> wrote:
>
> > the column type will limit the number of characters per row. A column
> > of
> > type TEXT will hold up to 65,535 characters but with LONGTEXT you can
> > put
> > up to 4,294,967,295 charcters into one row. I have an application with
> > Texts of up to 200 pages in one column. Full-Text Search is handling
> > this
> > very well.
>
>
> Thanks...
>
> Really?! If I can follow-up with another question, does experience
> suggest Full-Text Search handles a large number of such documents
> efficiently? For example, I am expecting to have (up to) one
> million documents in my database. I was considering breaking each
> document into paragraphs for search efficiency, but if Full-Text
> Search can search return results quickly on a large number of "long"
> (e.g. 10,000+ character) documents, my database has just become much
simpler.
I see no reason why not. AIUI, Full Text search breaks the documents up
into words and indexes each document by avery word in the document.
Breaking into paragraphs gives you an approximate position within the
document for a hit, and changes the behaviour for multiple keywords (they
must both be in the same pararaph) but should have little effect on the
efficiency of the index.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
