Solving Speed

We probably all know that solving a chall takes like 6.96 seconds here.
So, i wanted to speed that up.

Putting a breakpoint and stepping revealed that a new entry in the usergroup table takes very long.

The table has a composite primary key: userid and groupid.

I speeded up the process by adding another index:

ALTER TABLE `wc4_usergroup`
ADD INDEX `speedgid` (`ug_groupid`);

This reduces time in calculating a membercount / solvercount for a group.

You can now solve the challenges faster!
- gizmore

Doesn't seem to have an effect. on warbox updates at least.

I added two more INDEXES

mysql> ALTER TABLE `wc4_wc_regat` ADD INDEX `speedup_uid` (`regat_uid`);
Query OK, 106955 rows affected (1.56 sec)
Records: 106955 Duplicates: 0 Warnings: 0

mysql> ALTER TABLE `wc4_wc_regat` ADD INDEX `speedup_sid` (`regat_sid`);
Query OK, 106955 rows affected (1.35 sec)
Records: 106955 Duplicates: 0 Warnings: 0

But i cannot solve a single chall without any effort.
Please report if it got better.

- giz

Nope, still the same.

The speedup is significant already, imho, but not sure for some warboxes or challenges with > 1 points.

I am out of practice a little.

Anyway, i just wanted to notice that you should leave some support tasks for this gizmore guy...

read: big thx!