← Back to team overview

maria-discuss team mailing list archive

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



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/