the work to push down the limit clause for odbc table and mysql
>> table. You can refer to this pr：
>> https://github.com/apache/incubator-doris/pull/4707/files.
>>
>> If you want better performance of mapping table with limit clause, please
>> update doris version
table. You can refer to this pr：
> https://github.com/apache/incubator-doris/pull/4707/files.
>
> If you want better performance of mapping table with limit clause, please
> update doris version after 0.13.15.
>
>
>
> ____________
> From: Thomas Cai
mapping table with limit clause, please
update doris version after 0.13.15.
From: Thomas Cai
Sent: March 31, 2021 12:44
To: ling miao
Cc: dev@doris.apache.org
Subject: Re:Re: The performance issue about Doris mapping table
Dear Ling Miao,
Thanks for your
0.13.15.
From: Thomas Cai
Sent: March 31, 2021 12:44
To: ling miao
Cc: dev@doris.apache.org
Subject: Re:Re: The performance issue about Doris mapping table
Dear Ling Miao,
Thanks for your advice. Here is the result by looking for the profile. Any
more
.
From: Thomas Cai
Sent: March 31, 2021 12:44
To: ling miao
Cc: dev@doris.apache.org
Subject: Re:Re: The performance issue about Doris mapping table
Dear Ling Miao,
Thanks for your advice. Here is the result by looking for the profile. Any
more suggestions?
Query
Dear Ling Miao,
Thanks for your advice. Here is the result by looking for the profile. Any
more suggestions?
Query:
Summary:
Query ID: 3ef6a5a504e4466e-aeffd78390f003e6
Start Time: 2021-03-31 20:24:25
End Time: 2021-03-31 20:24:34
Total: 9s452ms
Query Type: Query
Que
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
Dear All,
I got a performance issue when I selected records(limit 1000) from a Doris
mapping table(MySQL,records were around 150K). It took less than 2s to look for
the same records from MySQL table directly, but it would take about 20s from
the Doris mapping table. My Doris version is 0.12 an
