CREATE INDEX IF NOT EXISTS idx_mapinfo_map ON mapinfo(Map);
CREATE INDEX IF NOT EXISTS idx_maps_map ON maps(Map);
CREATE INDEX IF NOT EXISTS idx_maps_server ON maps(Server);
CREATE INDEX IF NOT EXISTS idx_maps_points ON maps(Points);
CREATE INDEX IF NOT EXISTS idx_maps_stars ON maps(Stars);
CREATE INDEX IF NOT EXISTS idx_maps_timestamp ON maps(Timestamp);
CREATE INDEX IF NOT EXISTS idx_race_map ON race(Map);
CREATE INDEX IF NOT EXISTS idx_race_name ON race(Name);
CREATE INDEX IF NOT EXISTS idx_race_time ON race(Time);
CREATE INDEX IF NOT EXISTS idx_race_timestamp ON race(Timestamp);
CREATE INDEX IF NOT EXISTS idx_teamrace_map ON teamrace(Map);
CREATE INDEX IF NOT EXISTS idx_teamrace_name ON teamrace(Name);
CREATE INDEX IF NOT EXISTS idx_teamrace_time ON teamrace(Time);
CREATE INDEX IF NOT EXISTS idx_teamrace_timestamp ON teamrace(Timestamp);
vacuum; 
Is this for Datasette? Is teamrace.ID not indexed right now? a bit slow to query for teams now.
hard to get a vps that have a reasonable connection to china while being cheap
2
1
1
1
1
1
1
1
️ (@kimmonismus) on X
====================[ Build | game-server | Debug ]=============================
D:\JetBrains\CLion\bin\cmake\win\x64\bin\cmake.exe --build D:\CLion\ddnet\cmake-build-debug --target game-server -j 10
[0/2] Generating debug/libddnet_engine_shared.a
Finished `dev` profile [unoptimized + debuginfo] target(s) in 0.15s
[2/2] Linking CXX executable DDNet-Server.exe
FAILED: DDNet-Server.exe
C:\Windows\system32\cmd.exe /C "cd . && D:\JetBrains\CLion\bin\mingw\bin\g++.exe -g @CMakeFiles\game-server.rsp -o DDNet-Server.exe -Wl,--out-implib,libDDNet-Server.dll.a -Wl,--major-image-version,0,--minor-image-version,0 && cd ."
D:\JetBrains\CLion\bin\mingw\bin/ld.exe: cannot find debug/libddnet_engine_shared.a: No such file or directory
collect2.exe: error: ld returned 1 exit status
ninja: build stopped: subcommand failed.
I run rustup install stable-x86_64-pc-windows-msvc after rustup default stable-x86_64-pc-windows-msvc. Then I run the build but an error pops up. Can anyone help me? [0/2] Generating debug/libddnet_engine_shared.a
Finished `dev` profile [unoptimized + debuginfo] target(s) in 0.05s
[2/2] Linking CXX executable DDNet-Server.exe
FAILED: DDNet-Server.exe
C:\Windows\system32\cmd.exe /C "cd . && D:\Programs\JetBrains\CLion\bin\mingw\bin\g++.exe -g @CMakeFiles\game-server.rsp -o DDNet-Server.exe -Wl,--out-implib,libDDNet-Server.dll.a -Wl,--major-image-version,0,--minor-image-version,0 && cd ."
D:\Programs\JetBrains\CLion\bin\mingw\bin/ld.exe: cannot find debug/libddnet_engine_shared.a: No such file or directory
collect2.exe: error: ld returned 1 exit status
ninja: build stopped: subcommand failed.
1
