Consider the following statements
#1 New family is created so I have no data
create columnfamily Test (UserName varchar primary key, EmailAddress
varchar);
#2 Count how many rows I have
select count(1) from Test;
-Expected: 0
-Actual: 0
#3 Select all users with a specific email address
select *
select * from Users where UserName='me' or EmailAddress='m...@home.com';
Bad Request: line 1:40 mismatched input 'or' expecting EOF
Could someone tell me how to use OR conditions in CQL? I am able to find
examples of AND, but none for OR and it doesn't seem to work.
My misunderstanding, thanks for correcting me!
On Mon, Aug 20, 2012 at 4:32 PM, Hiller, Dean wrote:
> There is latency and throughput. These are two totally different things
> even for MySQL. If you are single threaded, each request (even with MySql)
> has to be delayed by 1ms or whatever you
elay per request and the other has .001, 1000 requests
> will be a one second delay tacked on(which is huge). This is why he
> suggested multi-threaded ;). Maybe there is some other factors as well.
>
> Dean
>
> From: Peter Morris mailto:mrpmor...@gmail.com>>
> Reply-To: &qu
I've set NoDelay = true on the socket, and although it is much better it is
still only giving me 500 record inserts per second over a 1Gbps crossover
cable - (I now also get 200 record inserts per second over wireless.)
I would expect the cross over to have much better performance than this.
Any
Thanks, I shall get onto the developer of the library :)
On Sun, Aug 19, 2012 at 10:13 PM, Peter Schuller <
peter.schul...@infidyne.com> wrote:
> You're almost certainly using a client that doesn't set TCP_NODELAY on
> the thrift TCP socket. The nagle algorithm is enabled, leading to 200
> ms la
t want to try the stress tool in the distribution.
>
>
>
>
> On 08/19/2012 02:09 PM, Peter Morris wrote:
>
> Hi all
>
> I have a Windows 7 machine (64 bit) with DataStax community server
> installed. Running a benchmark app on the server gives me 7000 inserts p
Hi all
I have a Windows 7 machine (64 bit) with DataStax community server
installed. Running a benchmark app on the server gives me 7000 inserts per
second. Running the same app on a networked client gives me only 5 inserts
per second. The two computers are connected directly via a cross over
c
