in hearing how
>MySQL's full text index works for your large dataset.
>
>Thanks,
>--jeff
>
>- Original Message -
>From: "Luke Muszkiewicz" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Sunday, February 24, 2002 6:30 PM
>Subject: RE:
t; <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 24, 2002 6:30 PM
Subject: RE: help with big table search
> Jaime:
>
> Have you tried creating a FULLTEXT index? If so, I'd like to hear about
> how well it works on such a large database.
>
> h
Jaime:
Have you tried creating a FULLTEXT index? If so, I'd like to hear about
how well it works on such a large database.
http://www.mysql.com/doc/F/u/Fulltext_Search.html
Best of luck.
-luke
Luke Muszkiewicz
Pure Development, LLC
http://puredev.com
> Hi,
>
> I have a table and currently ha
ssref on (eventlog.id=crossref.id and word =
'HELLO')
ORDER BY eventlog.id DESC LIMIT 20;
?
Regards,
Dan
> -Original Message-
> From: Jaime Teng [mailto:[EMAIL PROTECTED]]
> Sent: Monday, 25 February 2002 2:34 p.m.
> To: [EMAIL PROTECTED]
> Subject: help with bi
Hi,
I have a table and currently has about 1.6 million entries.
It is a table of events with date/time and description of the event.
mysql> describe eventlog;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extr
