Re: innodb tables problem

2002-05-07 Thread Heikki Tuuri
nf options as recommended in section 2 of http://www.innodb.com/ibman.html. Regards, Heikki - Original Message - From: "Oren Zeev-Ben-Mordehai" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Sent: Tuesday, May 07, 2002 5:26 PM Sub

Re: innodb tables problem

2002-05-07 Thread Heikki Tuuri
al Message - From: ""Oren Zeev-Ben-Mordehai"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, May 07, 2002 3:16 PM Subject: innodb tables problem > I have defined some InnoDB tables and try to feed one of them > with 3,000,000 records. >

innodb tables problem

2002-05-07 Thread Oren Zeev-Ben-Mordehai
I have defined some InnoDB tables and try to feed one of them with 3,000,000 records. Using a script piped to mysql. First I tried to insert the rows one by one. It worked very slow. I didn't wait to see if it ends. Next try was to fill some temporary table with the numbers 1..3,000,000. I was