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 it

Re: low performance inserting

2011-05-03 Thread charles THIBAULT
d.html: > "When loading a table from a text file, 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 > wrote: > > Hello everybody, > > > &

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. W