On Mon, Apr 08, 2002 at 01:32:59PM +0200, ddd wrote:
> 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 (ID
On Mon, Apr 08, 2002 at 08:25:01AM -0700, MySQL Newsgroup wrote:
> 1. Use PostgreSQL.
Why?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.47-max: up 61 days, processed 1,654,104,995
Subject: Re: 200 milions records
From: Vic Cekvenich <[EMAIL PROTECTED]>
===
1. Use PostgreSQL.
2. Use multi channel disk cache controller
3. Get rid of not NULL.
4. index a primary seqnecy key
It should be subsecond.
Vic
ddd wrote:
> HI,
>
> I want to insert into db 200.000
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