I was wondering the performance between a remote and local query.
I used iquery and -c option to pose a query to remote SciDB.
Also, I used -r option and the target is /dev/null.
In the code (iquery.cpp), there are count() and iterators to operate the chunks.
So, I measured count() and (iterator)++ processing time.
local query: iquery -aq “scan(data)” -r /dev/null
remote query: iquery -aq "scan(data) -r /dev/null -c remotehost
The result is that the local query (localhost) performance is better than the remote query performance (used scan query for same data).
Definitely, the local query is faster than the remote query. The count() and (iterator)++ processing time was reduced.
For taking chunks, probably, used APIs may be different in both queries.
- my guess is right?
- why is the count() also faster?
- Could you explain more details about the process?