phpshell
phpshell copied to clipboard
decrease database size by removing vld (helpers) output
While this output is useful, it is not needed in the db for all scripts, for eternity. We do currently have a dependency on it for generating functionCalls. The impact should be pretty significant, the output could decrease by roughly 60%:
select sum(length(raw)) from output; # 26 GiB
select sum(length(raw)) from output where id in(select output from result where version=(select id from version where name='vld')); # 16 GiB
Options:
- remove entirely
- (simple) replace with
$output = trigger('vld'); delete(); return $output - replace with real-time call (requires daemon to communicate output via additional table / call)
Implementing one of the two alternatives would allow for introducing additional helpers a lot easier, as we won't need to batch all inputs before showing the output online
implemented option 2 in d8f89e221a90f4e55609ff2b1f1aae2917990586
it works fine but option 3 is still preferred