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 of the running process. Take a look at where the entire query is slow. http://doris.apache.org/master/en/administrator-guide/running-profile.html#noun-interpretation Thomas Cai <thomas...@126.com> 于2021年3月31日周三 下午7:17写道： > 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 and I tried to > change several Doris configuration/variables, unfortunattely it didn't work. > > > Did someone meet the same situation before to provide any suggestions? > Whether proper configuration setting may solve the issue or have to wait > JDBC for SQL in version 0.14 release. > > > Appreciated for any feedback. > > > Best Regards, > Thomas
