Yes, it depends on the specific scenario. If you can provide the testing
scenario, SQL queries, and detailed cube design, then we can discuss it.

Best regards,

Shaofeng Shi 史少锋
Apache Kylin PMC
Email: [email protected]

Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: [email protected]
Join Kylin dev mail group: [email protected]




[email protected] <[email protected]> 于2019年9月2日周一 上午11:10写道:

>  But if each SQL  statement is different, how much can QPS reach?
> ------------------------------
> [email protected]
>
>
> *From:* ShaoFeng Shi <[email protected]>
> *Date:* 2019-09-02 10:52
> *To:* user <[email protected]>
> *Subject:* Re: query concurrency
> Hello,
>
> Usually, if the cube has been well designed and tunned, one Kylin server
> can support 50 to 150 QPS. From the Cisco team's experience, with enabling
> some advanced features like query cache and prepared statement, one Kylin
> server can support up to 500 QPS:
>
> https://kylin.apache.org/blog/2019/01/17/cisco-throughput-5x/
>
> If your QPS is not ideal, please try to tune a single query's performance
> and optimize the cube design.
>
> Best regards,
>
> Shaofeng Shi 史少锋
> Apache Kylin PMC
> Email: [email protected]
>
> Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
> Join Kylin user mail group: [email protected]
> Join Kylin dev mail group: [email protected]
>
>
>
>
> [email protected] <[email protected]> 于2019年8月26日周一 下午4:32写道:
>
>>
>> Hi:
>>     According to kylin's introduction, an ordinary server can accept
>> tens to hundreds of QPS. However, I found in the actual production that the
>> QPS of a query node can only reach single digits. It is reasonable to say
>> that the concurrency of a SpringBoot project is relatively high, and the
>> resolution speed of Calcite does not stop there.HBase's reading speed is no
>> problem. But the actual effect is so abnormal, what could be the problem?
>>
>> ------------------------------
>> [email protected]
>>
>>

Reply via email to