Username: 
Password: 
Restrict session to IP 

Solving Speed

Global Rank: 227
Totalscore: 94362
Posts: 1681
Thanks: 1358
UpVotes: 920
Registered: 16y 302d




Last Seen: 20h 28m
The User is Offline
Solving Speed
Google/translate0Thank You!1Good Post!0Bad Post! link
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
The geeks shall inherit the properties and methods of object earth.
Global Rank: 5
Totalscore: 549432
Posts: 223
Thanks: 229
UpVotes: 232
Registered: 15y 56d






Last Seen: 11s
The User is Online
RE: Solving Speed
Google/translate0Thank You!0Good Post!0Bad Post! link
Doesn't seem to have an effect. on warbox updates at least.
Global Rank: 227
Totalscore: 94362
Posts: 1681
Thanks: 1358
UpVotes: 920
Registered: 16y 302d




Last Seen: 20h 28m
The User is Offline
RE: Solving Speed
Google/translate0Thank You!0Good Post!0Bad Post! link
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
The geeks shall inherit the properties and methods of object earth.
Global Rank: 5
Totalscore: 549432
Posts: 223
Thanks: 229
UpVotes: 232
Registered: 15y 56d






Last Seen: 11s
The User is Online
RE: Solving Speed
Google/translate1Thank You!1Good Post!0Bad Post! link
Nope, still the same.
Global Rank: 227
Totalscore: 94362
Posts: 1681
Thanks: 1358
UpVotes: 920
Registered: 16y 302d




Last Seen: 20h 28m
The User is Offline
RE: Solving Speed
Google/translate0Thank You!0Good Post!0Bad Post! link
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!
The geeks shall inherit the properties and methods of object earth.
tunelko, quangntenemy, TheHiveMind, Z, balicocat, Ge0, samuraiblanco, arraez, jcquinterov, hophuocthinh, alfamen2, burhanudinn123, Ben_Dover, stephanduran89, braddie0, SwolloW, dangarbri, csuquvq have subscribed to this thread and receive emails on new posts.
1 people are watching the thread at the moment.
This thread has been viewed 1856 times.