優化前 SELECT * FROM member ORDER BY last_active LIMIT 50,5
優化後 SELECT * FROM member INNER JOIN (SELECT member_id FROM member ORDER BY last_active LIMIT 50, 5) USING (member_id)
有差那麼多嗎？改天試一下好了。
Mysql function UUID() 產生邏輯主鍵
HEX(REPLACE(UUID(), - , )) 存入 binary16會比較省空間，不過search呢？？
(唔，這一段測試有點狀況…@____@)
CRC32(long string) 存入 unsigned int 用來提高效率加快搜尋速度。
例如
set encode_url=CRC32(url_string), url= url_string
select * from table where encode_url=CRC32(url_string) AND url= url_string
咻~~加快search。
住戶編號:1139420
檢舉原因
心情: 
