I'm able to index 600,000 records in about 5 to 6 minutes on a dual PII
450
running Win2K and MySQL 4.0.0a
Similar stucture
ID
Title
Description
Indexing Title and Description.
On Wed, 2002-01-09 at 20:26, Jon Shoberg wrote:
I have a simple table with A LOT of data, 2.1M rows. this is
I have a simple table with A LOT of data, 2.1M rows. this is purely a
development/test/learning endeavor.
The table structure is:
ID- auto-increment
url - varchar(255)
topic - varchar(255)
about - tinytext
Anyone use fulltext indexing under this scenario? The DB server is a P3-866