mysql 4 fulltext - stable ?

2002-11-02 Thread ddd
Hello, What are your experiences with Mysql 4 and Fulltext? is it stable or should I still wait for final release? I realy need new functions of mysql 4, but i'm not sure if use it. thanx - Before posting, please check: ht

Re: full-text search (not in boolean mode)

2002-11-02 Thread ddd
i know ! but how to solve it ??! can anybody help how to search word with "-" thanx Paul DuBois wrote: At 21:45 +0100 11/1/02, ddd wrote: hello i'm using mysql 3.23.41 i want to search in fulltext indexed table for word "Down-Syndrom" but the result is the same l

full-text search (not in boolean mode)

2002-11-01 Thread ddd
hello i'm using mysql 3.23.41 i want to search in fulltext indexed table for word "Down-Syndrom" but the result is the same like when I search "138721-Syndrom".. WHY thanks SQL command: select IDpage, URL from news where match Words against ("Down-Syndrom");

fulltext - exact phrase

2002-05-29 Thread ddd
Hello I have a question, is possible to search on mysql 4.0 in fulltext index the exact phrase ? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (t

fulltext of 2GB data

2002-05-04 Thread ddd
Hello I want to make a fulltext searching of aprox. 2GB texts. Can you help how to do it ? what database ? I tried it with mysql, but when there was about 500MB, the insert of article takes about 6 seconds. hardware was: RAID 0 - 2x 10k U160 SCSI disks In what hardware should I invest that it

200 milions records

2002-04-08 Thread ddd
HI, I want to insert into db 200.000.000 records of type (int6,int6).. the structure is: CREATE TABLE word_page ( IDword mediumint(6) NOT NULL default '0', IDpage mediumint(6) NOT NULL default '0', KEY IDword (IDword) ) TYPE=MyISAM; What do you think of it,, how would be th