<p dir="auto">expect formart of insert like :</p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="// insert_with_muti_values
INSERT  INTO t_order_item (order_id , user_id , status , creation_date)
VALUES
	(1, 1, 'insert', '2017-08-08'),
	(2, 2, 'insert', '2017-08-08')
ON DUPLICATE KEY UPDATE status = 'init'

// insert_with_muti_set
INSERT  INTO t_order SET order_id = 1,
	user_id = 1,
	status = CONVERT(to_base64(aes_encrypt(1 , 'key')) USING utf8)
ON DUPLICATE KEY UPDATE status = VALUES(status)

// insert_with_select
INSERT  INTO t_order (order_id , user_id , status) 
SELECT order_id , user_id , status 
FROM t_order
WHERE 
	order_id = 1;
"><pre class="notranslate"><code class="notranslate">// insert_with_muti_values
INSERT  INTO t_order_item (order_id , user_id , status , creation_date)
VALUES
	(1, 1, 'insert', '2017-08-08'),
	(2, 2, 'insert', '2017-08-08')
ON DUPLICATE KEY UPDATE status = 'init'

// insert_with_muti_set
INSERT  INTO t_order SET order_id = 1,
	user_id = 1,
	status = CONVERT(to_base64(aes_encrypt(1 , 'key')) USING utf8)
ON DUPLICATE KEY UPDATE status = VALUES(status)

// insert_with_select
INSERT  INTO t_order (order_id , user_id , status) 
SELECT order_id , user_id , status 
FROM t_order
WHERE 
	order_id = 1;

</code></pre></div>
<h3 dir="auto">Which version of Sharding-Sphere do you using?</h3>
<p dir="auto">3.1.0</p>
<h3 dir="auto">Which project do you using? Sharding-JDBC or Sharding-Proxy?</h3>
<p dir="auto">Sharding-JDBC</p>
<h3 dir="auto">Expected behavior</h3>
<p dir="auto">All sharding tables' structure of a logic table are mostly same, so we can load one sharding table metadata instead of loading each of the sharding tables.</p>
<h3 dir="auto">Actual behavior</h3>
<p dir="auto">Loading all metadata from database, causing startup too slowly.<br>
check.table.metadata.enabled = false</p>
<p dir="auto"><a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/11688731/53022912-265f5a00-3497-11e9-8cce-941ad0092eda.png"><img width="1080" alt="96e686af-0c11-4285-9161-9f5c2135502c" src="https://user-images.githubusercontent.com/11688731/53022912-265f5a00-3497-11e9-8cce-941ad0092eda.png" style="max-width: 100%;"></a></p>
<p dir="auto"><a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/11688731/53023008-60c8f700-3497-11e9-8cfd-0ef887a42d2e.png"><img width="1182" alt="931d5ce9-a4c2-47ac-89ed-40706a420e51" src="https://user-images.githubusercontent.com/11688731/53023008-60c8f700-3497-11e9-8cfd-0ef887a42d2e.png" style="max-width: 100%;"></a></p>