ARK indexes

[Stuart Eve]

Hey (Andy)

I think we did some adjustments to some of the SQL calls and also put
some indexes on some of the SQL tables for Fasti that speeded up query
performance... I'm not sure that they got into the core code?

Can you post those fixes here, as I want to roll them out on the Chers
db.

Cheers

Stu

[Andy Dufton]

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.

[Andy Dufton]

Also FYI Stu, if you need any further information about the 2009 round
of fixes implemented by CR there is a folder in 0282L on Morgana
called 'CR bugs 2009' that has his implementations in it, as well as
some of the stuff that Guy was working on.

On Mar 17, 7:20 pm, Stuart Eve <stuart...@gmail.com> wrote: