Solving Speed
Global Rank: 198
Totalscore: 110647
Posts: 1795
Thanks: 1390
UpVotes: 961
Registered: 18y 258d
Last Seen: 64d 15h
The User is Offline
Solving Speed
Mar 04, 2023 - 17:11:29 (3y 240d)
Mar 04, 2023 - 17:11:29 (3y 240d)
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
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: 607613
Posts: 324
Thanks: 335
UpVotes: 341
Registered: 17y 12d
Last Seen: 113d 12h
The User is Offline
RE: Solving Speed
Mar 05, 2023 - 10:50:16 (3y 240d)
Mar 05, 2023 - 10:50:16 (3y 240d)
Doesn't seem to have an effect. on warbox updates at least.
Global Rank: 198
Totalscore: 110647
Posts: 1795
Thanks: 1390
UpVotes: 961
Registered: 18y 258d
Last Seen: 64d 15h
The User is Offline
RE: Solving Speed
Mar 05, 2023 - 16:35:46 (3y 239d)
Mar 05, 2023 - 16:35:46 (3y 239d)
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
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: 607613
Posts: 324
Thanks: 335
UpVotes: 341
Registered: 17y 12d
Last Seen: 113d 12h
The User is Offline
RE: Solving Speed
Mar 06, 2023 - 22:41:30 (3y 238d)
Mar 06, 2023 - 22:41:30 (3y 238d)
Nope, still the same.
Global Rank: 198
Totalscore: 110647
Posts: 1795
Thanks: 1390
UpVotes: 961
Registered: 18y 258d
Last Seen: 64d 15h
The User is Offline
RE: Solving Speed
Mar 19, 2023 - 14:56:38 (3y 225d)
Mar 19, 2023 - 14:56:38 (3y 225d)
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!
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.
quangntenemy, TheHiveMind, Z, balicocat, Ge0, arraez, jcquinterov, hophuocthinh, alfamen2, burhanudinn123, Ben_Dover, stephanduran89, braddie0, fpombal, 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 2486 times.
1 people are watching the thread at the moment.
This thread has been viewed 2486 times.