Re: low performance inserting

2011-05-04 Thread charles THIBAULT
I have understood my error. I was comparing bulk insert in MySQL with batch_insert in Cassandra I made this two tests from a remote machine I have made the same test with one insert per row in MySQL and it took 4mn28s but the result I have with the stress utility it seems to be abnormal, isn't

low performance inserting

2011-05-03 Thread charles THIBAULT
Hello everybody, first: sorry for my english in advance!! I'm getting started with Cassandra on a 5 nodes cluster inserting data with the pycassa API. I've read everywere on internet that cassandra's performance are better than MySQL because of the writes append's only into commit logs files.

Re: low performance inserting

2011-05-03 Thread charles THIBAULT
, use LOAD DATA INFILE. This is usually 20 times faster than using INSERT statements. -- Sylvain On Tue, May 3, 2011 at 12:30 PM, charles THIBAULT charl.thiba...@gmail.com wrote: Hello everybody, first: sorry for my english in advance!! I'm getting started with Cassandra on a 5 nodes