Re: Using map type with composite primary key causes significant performance decrease

2013-04-21 Thread aaron morton
> Write performance decreases. > Check the logs for WARN messages from the GCInspector. With 2Gb and only 2 Cores you may be seeing ParNew compaction which pauses the server. > Sometimes I have to wait 3-4 seconds to get a count even though there're only > couple of thousand small entries in

Re: Using map type with composite primary key causes significant performance decrease

2013-04-18 Thread Oleksandr Petrov
Write performance decreases. Reads are basically blocked, too. Sometimes I have to wait 3-4 seconds to get a count even though there're only couple of thousand small entries in a table. On Thu, Apr 18, 2013 at 8:37 PM, aaron morton wrote: > After about 1-2K inserts I get significant performance

Re: Using map type with composite primary key causes significant performance decrease

2013-04-18 Thread aaron morton
> After about 1-2K inserts I get significant performance decrease. A decrease in performance doing what ? Cheers - Aaron Morton Freelance Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 19/04/2013, at 4:43 AM, Oleksandr Petrov wrote: > Hi, > > I

Using map type with composite primary key causes significant performance decrease

2013-04-18 Thread Oleksandr Petrov
Hi, I'm trying to persist some event data, I've tried to identify the bottleneck, and it seems to work like that: If I create a table with primary key based on (application, environment, type and emitted_at): CREATE TABLE events (application varchar, environment varchar, type varchar, additional