Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
From: Arie Keren <arie@doubleverify.com>
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Date: Mon, 10 May 2010 02:08:43 -0500
Subject: RE: Extremly slow inserts on LAN
Thread-Topic: Extremly slow inserts on LAN
Thread-Index: Acrvhrb0NM27Jf+fSE6fZxCh5tqa1AAfYLLgAAAzaGAAAT+iAA==
Message-ID: 
 <D0C18662921DF14F983C53625DE8A7241E4C11F8F0@34093-MBX-C14.mex07a.mlsrvr.com>
References: 
 <D0C18662921DF14F983C53625DE8A7241E4C11F89E@34093-MBX-C14.mex07a.mlsrvr.com>
 <4BE6CB26.7000409@fourkitchens.com>
 <D0C18662921DF14F983C53625DE8A7241E4C11F8E7@34093-MBX-C14.mex07a.mlsrvr.com>
 <E9ACE71FFA2C07489EB082E48239F9C70DF42BE9E3@LTEXC001.adform.com>
In-Reply-To: <E9ACE71FFA2C07489EB082E48239F9C70DF42BE9E3@LTEXC001.adform.com>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

That solved the problem!
It also helps to increase the buffer size from the default value of 1024:
var transport =3D new TBufferedTransport(new TSocket("192.168.0.123", 9160)=
, 64*1024);

Thanks a lot!

-----Original Message-----
From: Viktor Jevdokimov [mailto:Viktor.Jevdokimov@adform.com]
Sent: May 10, 2010 8:57 AM
To: user@cassandra.apache.org
Subject: RE: Extremly slow inserts on LAN

We had similar experience.

Problem was with TSocket as transport alone:

        var transport =3D new TSocket("192.168.0.123", 9160);
        var protocol =3D new TBinaryProtocol(transport);
        var client =3D new Cassandra.Client(protocol);

Using TBufferedTransport helped a lot:

        var transport =3D new TBufferedTransport(new TSocket("192.168.0.123=
", 9160));
        var protocol =3D new TBinaryProtocol(transport);
        var client =3D new Cassandra.Client(protocol);

Viktor


-----Original Message-----
From: Arie Keren [mailto:arie@doubleverify.com]
Sent: Monday, May 10, 2010 8:51 AM
To: user@cassandra.apache.org
Subject: RE: Extremly slow inserts on LAN

No - just Windows.
So I'm going to do some experiments to isolate the cause:
- use java client on windows
- use linux server
- use java client on linux

Thanx


-----Original Message-----
From: David Strauss [mailto:david@fourkitchens.com]
Sent: May 09, 2010 5:48 PM
To: user@cassandra.apache.org
Subject: Re: Extremly slow inserts on LAN

>From a naive (not caring about Cassandra internals) basis, the first step i=
s to isolate whether the problem is on the client or server side.
Have you tried a Linux-based server or a Linux-based client?

On 2010-05-09 14:06, Arie Keren wrote:
> While making our first steps with Cassandra, we experience slow
> inserts working on LAN.
>
> Inserting 7000 keys with 1 column family takes about 10 seconds when
> Cassandra server running on the same host with the client.
>
> But when server runs on a different host on LAN, the same inserts take
> more than 10 (!) minutes.
>
> In both cases Cassandra server contains a single node.
>
>
>
> We use Cassandra version 0.6.0 running on Windows server 2008.
>
> The client is .NET c# application.

--
David Strauss
   | david@fourkitchens.com
Four Kitchens
   | http://fourkitchens.com
   | +1 512 454 6659 [office]
   | +1 512 870 8453 [direct]


__________ Information from ESET NOD32 Antivirus, version of virus signatur=
e database 4628 (20091122) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


__________ Information from ESET NOD32 Antivirus, version of virus signatur=
e database 4628 (20091122) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


__________ Information from ESET NOD32 Antivirus, version of virus signatur=
e database 4628 (20091122) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com