Sorry about that, bringing a lot of the fasti items back into the core
as fasti is actually running on earlier than 0.6 and so I have to work
them in without just copying over. It is on the list of general ARK
admin to be tackled in the coming months.
In the meantime, here are the indexes (to be run as SQL straight from
phpMyAdmin):
CREATE INDEX cor_tbl_attribute_idx_item ON cor_tbl_attribute
(itemkey,itemvalue);
CREATE INDEX cor_tbl_attribute_idx_attr ON cor_tbl_attribute
(attribute);
CREATE INDEX cor_tbl_action_idx_item ON cor_tbl_action
(itemkey,itemvalue);
CREATE INDEX cor_tbl_action_idx_actor_itemkey ON cor_tbl_action
(actor_itemkey);
CREATE INDEX cor_tbl_action_idx_actor_itemvalue ON cor_tbl_action
(actor_itemvalue);
Not sure if it's worth looking into other indexing options for the
tables while we're at it, there could be other things to speed up
functions in non-fasti applications?
A.