MySQL Forums
Forum List  »  Newbie

Best MySQL schema for ZIP-code based weather prediction data?
Posted by: USASnow DayCalculator
Date: December 19, 2025 04:31AM

Hi everyone,

I’m working on a small project that predicts school closures based on
weather conditions (snowfall, temperature, alerts).

The system collects:
- ZIP code
- Hourly weather metrics
- Probability scores (0–100)
- Timestamped updates

I’m unsure whether a single table with indexed ZIP codes is enough,
or if partitioning by state/date would be better for performance.

Any advice on schema design or indexing strategies would be appreciated.
Thanks!

Options: ReplyQuote


Subject
Written By
Posted
Best MySQL schema for ZIP-code based weather prediction data?
December 19, 2025 04:31AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.