Should I use one or two tables for summary data?
From: Victor Porton <porton_at_narod.ru>
Date: Mon, 06 Feb 2017 17:51:43 +0200
Message-ID: <o7a62o$6c3$1_at_gioia.aioe.org>
[Quoted] Please advise:
Date: Mon, 06 Feb 2017 17:51:43 +0200
Message-ID: <o7a62o$6c3$1_at_gioia.aioe.org>
[Quoted] Please advise:
[Quoted] I need to store data grouped by days and by producers and also summary data, that is the result of SUM() (for all producers) grouped by days.
Should I make two tables (one for producers data and one for summary one) or one table with `ProducerID IS NULL` indicating the summary data (sum for all producers)?
Don't advise not to store the summary data and use SUM() instead, because I want it to be fast in retrieval.
[Quoted] The data is also grouped by other fields.
-- Victor Porton - http://portonvictor.orgReceived on Mon Feb 06 2017 - 16:51:43 CET