[GitHub] [incubator-shardingsphere] xfyang1989 commented on issue #3215: SQL execution is slow under sub-database sub-table

xfyang1989 commented on issue #3215: SQL execution is slow under sub-database sub-table URL: https://github.com/apache/incubator-shardingsphere/issues/3215#issuecomment-540997507 I understand, it may be my sql dynamic, causing the sharingspehere to think that every time the new sql will b

[GitHub] [incubator-shardingsphere] xfyang1989 commented on issue #3215: SQL execution is slow under sub-database sub-table

xfyang1989 commented on issue #3215: SQL execution is slow under sub-database sub-table URL: https://github.com/apache/incubator-shardingsphere/issues/3215#issuecomment-540921593 Database connection pool is HikariCP This is

[GitHub] [incubator-shardingsphere] xfyang1989 commented on issue #3215: SQL execution is slow under sub-database sub-table

xfyang1989 commented on issue #3215: SQL execution is slow under sub-database sub-table URL: https://github.com/apache/incubator-shardingsphere/issues/3215#issuecomment-540921409 Every time the first query like this SQL is very slow, the second time may be due to the underlying cache.

[GitHub] [incubator-shardingsphere] xfyang1989 commented on issue #3215: SQL execution is slow under sub-database sub-table

xfyang1989 commented on issue #3215: SQL execution is slow under sub-database sub-table URL: https://github.com/apache/incubator-shardingsphere/issues/3215#issuecomment-540886682 > If care about performance, please use parameter marker instead of inline literals. Is there a sample,

[GitHub] [incubator-shardingsphere] xfyang1989 commented on issue #3215: SQL execution is slow under sub-database sub-table

xfyang1989 commented on issue #3215: SQL execution is slow under sub-database sub-table URL: https://github.com/apache/incubator-shardingsphere/issues/3215#issuecomment-540863997 This is mysql execution time ![{89392B63-E470-46F0-9F18-4344EBF28009}_20191011093803](https://user-images.g

[GitHub] [incubator-shardingsphere] xfyang1989 commented on issue #3215: SQL execution is slow under sub-database sub-table

xfyang1989 commented on issue #3215: SQL execution is slow under sub-database sub-table URL: https://github.com/apache/incubator-shardingsphere/issues/3215#issuecomment-540861638 the version 4.0.0-RC2, The parameter (sql.slow) is set to false. A lot of similar SQL is slow, causing sev