Accessing Cratedb via HTTP Endoint vs PostgreSQL Wire Protocol

Question

I was wondering if anyone has tried comparing the speed in querying (lets just say any arbitrary query for this exercise) using either HTTP end point and the PostgreSQL connection to cratedb.

Considering what's under the hood is elastic search (lucene) engine which is HTTP based and Crate having its Postgresql spin.

score 2 · Accepted Answer · answered Sep 17 '18 at 12:20

2

I reached out to CrateIO and Peter from CrateIO confirmed that using HTTP would be faster than using PostrgreSQL

answered Sep 17 '18 at 12:20

metase

1,169
2
16
29

By PostgreSQL, do you mean JDBC inserts ? I am reading this as JDBC inserts are slower than insertion via HTTP end point. Is this correct understanding? Do you have any idea of comparison of speed of HTTP end point and "Copy From" command ? – vinayakshukre Dec 24 '18 at 12:28
@vinayakshukre not quite, I was using datareader (C#) via the 5432 port, I did conduct comparison and it seemed that while the actual query seemed to perform better using datareader option the opening of the connection and time it took outperformed HTTP method. (once you issued 2nd HTTP call it was quicker than traditional sql connection). – metase Dec 28 '18 at 18:45

Accessing Cratedb via HTTP Endoint vs PostgreSQL Wire Protocol

1 Answers1