search

quantified-uncertainty / metaforecast

Fetch forecasts from prediction markets/forecasting platforms to make them searchable. Integrate these forecasts into other services.
https://metaforecast.org/
MIT License
57 stars 5 forks source link

Build frontpage table by storing ids only #49

Closed berekuk closed 2 years ago

berekuk commented 2 years ago

Right now frontpage table is filled with huge json fields.

It'd be better to keep a simple table with 50 ids, and then join it with questions in getFrontpage. I'm pretty sure the performance won't degrade.

(And frontpage_full is entirely unnecessary, since the same effect can be achieved with SELECT * FROM questions).

PS: This is not really important, but it's part of the work I'd like to do on normalizing the database.

NunoSempere commented 2 years ago

I'm pretty sure the performance won't degrade

No strong opinions, happy to defer to you