Solving Speed
Posizione globale: 198
Punteggio totale: 110647
Posts : 1795
Grazie: 1390
Voti+: 961
Registrato: 18a 259gg
Ultima visita: 65gg 14ore
L'utente è Offline
Solving Speed
04 Mar 2023 - 17:11:29 (3a 241gg)
04 Mar 2023 - 17:11:29 (3a 241gg)
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.
Posizione globale: 5
Punteggio totale: 607613
Posts : 324
Grazie: 335
Voti+: 341
Registrato: 17a 13gg
Ultima visita: 114gg 10ore
L'utente è Offline
RE: Solving Speed
05 Mar 2023 - 10:50:16 (3a 241gg)
05 Mar 2023 - 10:50:16 (3a 241gg)
Doesn't seem to have an effect. on warbox updates at least.
Posizione globale: 198
Punteggio totale: 110647
Posts : 1795
Grazie: 1390
Voti+: 961
Registrato: 18a 259gg
Ultima visita: 65gg 14ore
L'utente è Offline
RE: Solving Speed
05 Mar 2023 - 16:35:46 (3a 240gg)
05 Mar 2023 - 16:35:46 (3a 240gg)
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.
Posizione globale: 5
Punteggio totale: 607613
Posts : 324
Grazie: 335
Voti+: 341
Registrato: 17a 13gg
Ultima visita: 114gg 10ore
L'utente è Offline
RE: Solving Speed
06 Mar 2023 - 22:41:30 (3a 239gg)
06 Mar 2023 - 22:41:30 (3a 239gg)
Nope, still the same.
Posizione globale: 198
Punteggio totale: 110647
Posts : 1795
Grazie: 1390
Voti+: 961
Registrato: 18a 259gg
Ultima visita: 65gg 14ore
L'utente è Offline
RE: Solving Speed
19 Mar 2023 - 14:56:38 (3a 226gg)
19 Mar 2023 - 14:56:38 (3a 226gg)
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 utenti hanno sottoscritto il thread e ricevo le E-Mail di notifica.
1 persone stanno visualizzando il thread.
Questo thread è stato visualizzato 2488 volte.
1 persone stanno visualizzando il thread.
Questo thread è stato visualizzato 2488 volte.