Thank you for posting this proposal, some queries are indeed slower and we can start by optimising the query overhead of the database first
Congxian Qiu <qcx978132...@gmail.com> 于2024年7月11日周四 18:40写道： > Hi devs, > We have encountered some problems with Rest API access not working > efficiently when using Amoro recently, made a collation, and suggested some > possible solutions in the doc[1], please let me know what you think about > it, thanks. > > The problem is summarised below: > 1. Amoro reads too many rows of data(some of which we do not need) each > time it accesses the DB, which results in slow access. > 2. Amoro needs to access the external Catalog(e.g. HiveMetaStore) (multiple > times), resulting in slow access. > > [1] https://docs.qq.com/doc/DQU9sZ2RsdmRYSE1V > > Best, > Congxian >
