Received: from mail.isolution.de (mail.netarchitects.technopark.gmd.de [193.175.164.98]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA13134 for ; Sat, 12 Jun 1999 04:12:20 -0400 (EDT) (envelope-from alex@alexander-schneider.de) Received: from [192.168.147.132] (193.175.164.97) by mail.isolution.de with SMTP (Eudora Internet Mail Server 2.2.2); Sat, 12 Jun 1999 10:15:05 +0200 Subject: Full-Text-Indexing Date: Sat, 12 Jun 1999 10:11:31 +0200 x-sender: alex%alexander-schneider.de@mail.alexander-schneider.de x-mailer: Claris Emailer 2.0v3, January 22, 1998 From: Alexander Schneider To: Mime-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Message-ID: <1282947191-50950897@mail.isolution.de> Hello, I am also in need of FTI and looked iin the script from Maarten Boeklhold. I have several questions regarding this: 1) Why should I use "varchar(n)" instead of "text" though the space for a varchar-field is larger than text (varchar: 4byte+n, text: 2byte+n)? Is it more efficient for queries? 2) I would like a table where I can insert/update/delete the stop-words instead of an array inside the code. This would also help in lower the words to search for in the query. Are there any grave performance penaltys for this solution? It is much more flexible and I would trade a small performance loss for this flexibility. [I cannot program in C so maybe there is a volunteer who could write this little snippet for me? :-)] Thanx for any helpful comments! Alex Schneider