SjonHortensius / 3v4l_org

An online php shell
51 stars 7 forks source link

decrease database size by removing vld (helpers) output #1

Open SjonHortensius opened 1 year ago

SjonHortensius commented 1 year ago

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:

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

SjonHortensius commented 1 year ago

implemented option 2 in d8f89e221a90f4e55609ff2b1f1aae2917990586

it works fine but option 3 is still preferred