maria-discuss team mailing list archive

Thread
Date

New Question: when archive can support index to speed up select peformance?

To: maria-discuss@xxxxxxxxxxxxxxxxxxx
From: AskMonty KB <noreply@xxxxxxxxxxxx>
Date: Sun, 17 Apr 2016 07:50:04 -0000

Hello,

A new question has been asked in "Archive" by yixuan_huang. Please answer it at http://mariadb.com/kb/en/when-archive-can-support-index-to-speed-up-select-peformance/ as the person asking the question may not be subscribed to the mailing list.

--------------------------------
Hello, when i used innodb, w/o index it will cost 2 mins for select, w/ index (two columns), it only costs 20 secs. due to large size of innodb, i convert innodb to archive engine, it save space lots, but failed to create index. previously, i want to extend primary key with those two columns, but failed due to max length should be 8 bytes. any suggestions? thanks!
--------------------------------

To view or answer this question please visit: http://mariadb.com/kb/en/when-archive-can-support-index-to-speed-up-select-peformance/