200 milions records

[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 the speed after then when i
 do simple select query ... for example "Select IDpage where IDword=44"
 
 What should I do for best performance?
 
 thanks
 regards 
 _ddd
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

fulltext of 2GB data

[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 works fast.. or isn't better MSSQL
?

thanks




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

fulltext - exact phrase

[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/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

full-text search (not in boolean mode)

[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");


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

[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 like when I search "138721-Syndrom"..
WHY 


"-" isn't considered part of a word so you're really searching for
"down" or "syndrom" in the one case and "138721" or "syndrom" in the
other.  Both searches will match records that contain "syndrom".



thanks

SQL command:

select IDpage, URL from news where match Words against ("Down-Syndrom");




.





-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql 4 fulltext - stable ?

[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:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php