[digitalpoint]

The indexes defined in the iTrader table are not scalable at ALL. It's causing full table scans for queries and joins done when you are looking at iTrader stuff for any user. This was causing our user table to have locking issues since those queries are joined to the user table, which in turn causes everything in the forum to slow down (even if it has nothing to do with iTrader).

1. The index rateid index has no need for it to include the dateline column in the index.

2. The index rateduserid is an exact duplicate of the rateid index. This index should include rateduserid and dateline columns (it incorrectly includes rateid and dateline).

3. An index for rateduserid + buyselltrade columns is needed.

I've made those changes to our itrader table and now our itrader table (which has 526,000+ iTrader ratings) does not cause issues any longer.

This is what our indexes look like now:



Hopefully we will see index fixes in a future version of iTrader package?