search

matrixorigin / matrixone

Hyperconverged cloud-edge native database
https://docs.matrixorigin.cn/en
Apache License 2.0
1.77k stars 275 forks source link

[Tech Request]: Performance improvement of prepared primary key point selection on a small table. #14469

Open fengttt opened 8 months ago

fengttt commented 8 months ago

Is there an existing issue for the same tech request?

Does this tech request not affect user experience?

What would you like to be added ?

Performance improvement on this most simple case.

Why is this needed ?

This is probably simplest query a database runs. However this is critical, as it measures how good is our basic code performance/quality. This simple work is critical for TP performance as all select, insert/upd/del, all need to go through the code path.

Additional information

No response

fengttt commented 8 months ago

https://github.com/matrixorigin/matrixone/issues/14505

fengttt commented 8 months ago

https://github.com/matrixorigin/MO-Cloud/issues/2457

fengttt commented 2 months ago

[ cn_2_select_star_2.out.gz ](select * from emptyTable)