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/ _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
