Re: Warning, Found xxx parts Should be: 0 parts

2002-02-17 Thread Amir Aliabadi
I had a typo I was trying to use myisamchk -r not -f to fix it which did not fix it. myisamchk -o seems to fix the problem. The real question is why am i getting this when creating index(s). Although I'm using the Alpha version, I don't get a warm fuzzy Any responses on what could be

Re: Distributed Fulltext?

2002-02-07 Thread Amir Aliabadi
How do you make something like this fault tolerant? The answer is probably what I suspect, 2 of every thing. How does the aggregator handle this or are these machines in a cluster? We are thinking of how to rebuild our fulltext search. Currently it is in MS SQL 7.0 - MySQL 4.0 seems to blow

Re: Suggestions - FullText ??

2002-01-12 Thread Amir Aliabadi
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

RE: Full Search

2002-01-03 Thread Amir Aliabadi
I've been looking hard at the FULLTEXT features of MySQL 4.0.1 on Linux and 4.0.0a on Win32 and comparing it to MS SQL 2000 / and MS SQL 7.0 as well as MySQL 3.XX.XX (latest stable release). MySQL 4 on Win2K (dual 550 1gig memory) can crawl 90MB of data in about 5 minutes . MS SQL 7 and 2000 on