Re: The performance issue about Doris mapping table

Ok, I see. Thanks for syncing information Ling Miao Thomas Cai 于2021年4月6日周二 上午11:40写道： > Ling Miao， > > Yes，your understanding is correct. Almost the same based on the test > result. > > Thomas > Thomas Cai > 邮箱：thomas...@126.com > >

Re: The performance issue about Doris mapping table

> Thanks for the info about limit clause. Actually I did try to query the whole records without limit both in MySql and Doris. The situation was almost the same. If you use doris to query the whole mysql table without limit, it is possible that the performance gap is large The reason is that the am

Re: The performance issue about Doris mapping table

Hi All， Share with you：I changed the table engine type of the original MySQL table from InnoDB to MYISAM. Then rebuild the mapping table in Doris. The query performance is almost the same as in MySQL directly. Best Regards， Thomas | | Thomas Cai 邮箱：thomas...@126.com | Signature is customiz

Re: The performance issue about Doris mapping table

Dear Lee， Thanks for the info about limit clause. Actually I did try to query the whole records without limit both in MySql and Doris. The situation was almost the same. Regards Thomas | | Thomas Cai 邮箱：thomas...@126.com | Signature is customized by Netease Mail Master On 04/01/2021 11:50,

Re: The performance issue about Doris mapping table

Hi Thomas Cai, Doris's mapping table read performance is indeed slightly worse than the direct read mysql table performance. *But your case should not be affected.* It may be that some optimizations of our later versions are not in 0.12 version. You can use this document to print out the profile