[
https://issues.apache.org/jira/browse/CALCITE-5054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17514613#comment-17514613
]
itxiangkui commented on CALCITE-5054:
-------------------------------------
We also did a little testing and came to a similar conclusion...
> Avatica Jdbc layer: Json vs ProtoBuf performance
> ------------------------------------------------
>
> Key: CALCITE-5054
> URL: https://issues.apache.org/jira/browse/CALCITE-5054
> Project: Calcite
> Issue Type: Bug
> Components: avatica, jdbc-driver
> Reporter: Shiven Dvrk
> Priority: Major
>
> We have run some benchmarks and also observed the similar behavior with our
> usecase testing, it looks like Protobuf serialization seems to be slower than
> JSON serialization at avatical layer.
>
> We have used a simple query like this:
> select Field1, Field2, Field3, Field4, Field5, Field6 from T3
> Field1 to Field 3 are of SqlTypeName.BIGINT type
> Field4 to Field6 are of SqlTypeName.DECIMAL type
> We had case where we project more than 500K rows so we tried some variations
> on benchmarking but we see that protobuf is slower than json.
> We are wondering why protobuf is slower? does anyone know if there is
> anything we might be missing?
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
