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 r

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

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 > expe

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 thi

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 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

Re: Large text searches

2001-02-01 Thread Angela
What if, when the business is added, there are a certain number of textboxes, I'll use 10 as an example, and for that business you can put in up to 10 phrases that someone might search for that business with. Then you don't need to put any other phrases in the database, just single words. This w

Re: Large text searches

2001-02-01 Thread Anna
- Original Message - From: "Geoff Coffey" <[EMAIL PROTECTED]> >I'm trying to decide how to enable searching from a web > form. Hi, I have a similar question. I have a table of business. I need to be able to search the title and description. Right now I have just your plain WHERE busines

Large text searches

2001-02-01 Thread Geoff Coffey
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 text of a resume and the other

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