Hi Herbert,
I was reading both your threats once more carefully (the original post and the
repost).
1) I assume you are using the MyISAM table format.
You wrote that you have 400 text documents with each ~3.75 MB size.
2) How is the data access trend to such documents ? Do you update them all
Hi Kunzmann,
I might be wrong but to answer your question I think three things are
necessary:
1) we will need to know the table structure(s)
2) we wil need to know which column you indexed
3) we wil need to know which request(s) you used
Is it possible that you indexed a column in the big tabl
Hello All.
I have a table that is about 1.5GB with about 400 records.
As you can tell, every record is about 4MB, all of which is
text.
I've created a fulltext index on the table, with
> alter table table2002 add fulltext data (data);
After this is done (takes about 20 minutes to do) I check
out
