lazyboy had a thread-based connection pool last time I checked, so he should just have to thread his test loop for it to use multiple connections. MySQL should suffer the same general problem though, although I don't know the specifics of the MySQLdb module. Based on his test, it's accurate to say that given 4m records MySQL is substantially less latent on reads.
Michael On Sat, Nov 14, 2009 at 11:17 AM, Brandon Williams <[email protected]> wrote: > On Sat, Nov 14, 2009 at 5:47 AM, ruslan usifov <[email protected]> > wrote: >> >> Hello! >> >> I'm new in cassandra son i can misunderstand some things. >> >> In follow "benchmark". I have insert 4000000 records like this > > *snip* >> >> # Define your cluster(s) >> connection.add_pool('test', ['localhost:9160']) > > This is your problem, you're only using one connection. Use 20+ and it will > be much faster, however it's unlikely that a single python process will be > able to truly push Cassandra to the limit. That said, take a look at > test/system/stress.py. > -Brandon
