Hi
Actually we run on amazon EC2 large instance = 7.5 GB memory and we don't
use ESB only local disk as /mnt
here is my code o insert the data :
public void insertChannelShow(String showId, String channelId, String
airDate, String duration, String title, String parentShowId, String genre,
String price, String subtitle) throws Exception {
Calendar calendar = Calendar.getInstance();
dateFormat.setCalendar(calendar);
Date air = dateFormat.parse(airDate);
calendar.setTime(air);
String key = String.valueOf(calendar.getTimeInMillis()) + ":" +
showId + ":" + channelId;
long timestamp = System.currentTimeMillis();
cassandraClient.insert("Keyspace1",
key,
new ColumnPath("channelShow", null,
("duration").getBytes("UTF-8")),
duration.getBytes("UTF-8"),
timestamp,
ConsistencyLevel.ONE);
cassandraClient.insert("Keyspace1",
key,
new ColumnPath("channelShow", null,
("title").getBytes("UTF-8")),
title.getBytes("UTF-8"),
timestamp,
ConsistencyLevel.ONE);
cassandraClient.insert("Keyspace1",
key,
new ColumnPath("channelShow", null,
("parentShowId").getBytes("UTF-8")),
parentShowId.getBytes("UTF-8"),
timestamp,
ConsistencyLevel.ONE);
cassandraClient.insert("Keyspace1",
key,
new ColumnPath("channelShow", null,
("genre").getBytes("UTF-8")),
genre.getBytes("UTF-8"),
timestamp,
ConsistencyLevel.ONE);
cassandraClient.insert("Keyspace1",
key,
new ColumnPath("channelShow", null,
("price").getBytes("UTF-8")),
price.getBytes("UTF-8"),
timestamp,
ConsistencyLevel.ONE);
cassandraClient.insert("Keyspace1",
key,
new ColumnPath("channelShow", null,
("subtitle").getBytes("UTF-8")),
subtitle.getBytes("UTF-8"),
timestamp,
ConsistencyLevel.ONE);
}
of course I've initialized my connection like this :
tr = new TSocket(server, 9160);
TProtocol proto = new TBinaryProtocol(tr);
cassandraClient = new Client(proto);
tr.open();
I've actually 2 machine on amazon EC2. 1 large from here I run the insert
data process and cassandra. The second machine just run cassandra but it's
on small instance just 2GB memory.
Thanks
On Sat, Nov 7, 2009 at 12:05 AM, Michael Greene <[email protected]>wrote:
> On Fri, Nov 6, 2009 at 10:54 AM, Richard grossman <[email protected]>
> wrote:
> > I know the test is not very accurate because the cassandra and oracle db
> > doesn't run on the same hardware but there is really a big difference.
> Do they run on comparable hardware? Hardware specs + configuration
> have a clear impact on Cassandra performance -- what's your
> environment like? This is slow even for a recent laptop though, so
> there's probably something else wrong.
>
> Michael
>
