Slow reading data from set


#1

Original Postby moriya » Fri Feb 21, 2014 2:35 am

Hi all, I had tested write speed on aerospike 3 server, it amazing, TPS over 2000 on a single server without any problem!

However, I try to read data from aerospike 3 via aql, it consume me over 2 sec to complete 5 records

aql> select * from test.testdata_20140123


5 rows in set (2.747 secs)

Any idea?

Thanks!!


#2

Postby young » Sat Mar 08, 2014 12:00 pm

Aerospike’s design has a smart client built in that gets data from the database cluster on how data is distributed. This means that for a new process, performance will be very good once it gets that information. However, there is a startup cost. When you run an AQL request, the client will connect to the server to get the distribution information and then issue the request. So there will always be an initial lag.


#3

Postby moriya » Sun Mar 16, 2014 10:07 pm

Ic…Thanks for your information!!