Re: Large text searches

2001-02-01 Thread Steve Ruby
Geoff Coffey wrote: I am new here... I am in the process of migrating a site built with FileMaker Pro to MySQL and PHP mostly because filemaker's web capabilities are too limiting. In one situation, we have a database of about 20,000 rows that contains two text columns. One is the full

Re: Large text searches

2001-02-01 Thread Gonzalo Aguilar
Geoff Coffey wrote: I am new here... I am in the process of migrating a site built with FileMaker Pro to MySQL and PHP mostly because filemaker's web capabilities are too limiting. In one situation, we have a database of about 20,000 rows that contains two text columns. One is the full

Re: Large text searches

2001-02-01 Thread Carsten Gehling
From: "Geoff Coffey" [EMAIL PROTECTED] Sent: Thursday, February 01, 2001 5:25 PM I am in the process of migrating a site built with FileMaker Pro to MySQL and PHP mostly because filemaker's web capabilities are too limiting. In one situation, we have a database of about 20,000 rows that

Re: Large text searches

2001-02-01 Thread Geoff Coffey
on 2/1/01 1:36 PM, Gonzalo Aguilar at [EMAIL PROTECTED] wrote: Making search engines is not a trivial thing, but this may be an aproach... I appreciate all the replies. In my original post I also asked about the FULL TEXT index type. If I may ask again, has anyone had any experience with

RE: Large text searches

2001-02-01 Thread Sander Pilon
on 2/1/01 1:36 PM, Gonzalo Aguilar at [EMAIL PROTECTED] wrote: Making search engines is not a trivial thing, but this may be an aproach... I appreciate all the replies. In my original post I also asked about the FULL TEXT index type. If I may ask again, has anyone had any experience

Re: Large text searches

2001-02-01 Thread Geoff Coffey
on 2/1/01 4:05 PM, Sander Pilon at [EMAIL PROTECTED] wrote: on 2/1/01 1:36 PM, Gonzalo Aguilar at [EMAIL PROTECTED] wrote: Making search engines is not a trivial thing, but this may be an aproach... I appreciate all the replies. In my original post I also asked about the FULL TEXT

Re: Large text searches

2001-02-01 Thread Matthias Urlichs
Hi, Sander Pilon: FULLTEXT indexes are about 95% of the size of the table, and they can perform quite well or very slow, depending on what you do. For my use (a trouble-ticket database), they behaved extremely poorly, unfortunately. The tickets frequently are over a MByte in size, which