> I have a table that has a few short text fields [text(4000), text(1000)]
> I would like to index. Do you think it is a good idea to index them
> "simply", or is it better if I create auxilary fields which hold the MD5
> for the text fields and index those? Would that be faster?
Try 'Fulltext
On Friday 11 June 2004 07:00 am, Fagyal, Csongor wrote:
> Hi,
>
> I have a table that has a few short text fields
> [text(4000), text(1000)] I would like to index. Do
> you think it is a good idea to index them "simply",
> or is it better if I create auxilary fields which
> hold the MD5 for the tex
On Friday, June 11, 2004, 7:00:39 AM, Csongor wrote:
FC> Hi,
FC> I have a table that has a few short text fields [text(4000), text(1000)]
FC> I would like to index. Do you think it is a good idea to index them
FC> "simply", or is it better if I create auxilary fields which hold the MD5
FC> for th
Hi,
I have a table that has a few short text fields [text(4000), text(1000)]
I would like to index. Do you think it is a good idea to index them
"simply", or is it better if I create auxilary fields which hold the MD5
for the text fields and index those? Would that be faster?
Thank you,
- Csong
On Mon, May 20, 2002 at 04:33:41PM +0200, andy wrote:
> Thank you Egor for you reply.
>
> I did read about indexing text column on the mysql site. So I tryed
> to index my column like described. After 1 hour, I had to reboot my
> machine because there was no other way.
No other
Thank you Egor for you reply.
I did read about indexing text column on the mysql site. So I tryed to index
my column like described. After 1 hour, I had to reboot my machine because
there was no other way. All the cpu was bussy and it seemed to me to be an
endless loop. After rebooting I had to
andy,
Sunday, May 19, 2002, 7:06:00 PM, you wrote:
a> I am wondering if it would be anyhow possible to make a search on a mysql
a> textfield faster. Right now the table contains 294000 entries and takes
a> about 40 MB of space. Is there a way to apply a index with a resonable
a> amount of disk sp
Hi there,
I am wondering if it would be anyhow possible to make a search on a mysql
textfield faster. Right now the table contains 294000 entries and takes
about 40 MB of space. Is there a way to apply a index with a resonable
amount of disk space? I am also not so sure if I should use text or
sm