103 reputation
3
bio website cird.com.ar
location Argentina
age
visits member for 1 year, 7 months
seen May 16 '13 at 19:06
void openEnding()
{

Dec
21
awarded  Scholar
Dec
21
accepted Design database to query a date range for scheduling
Dec
14
awarded  Editor
Dec
14
revised Design database to query a date range for scheduling
typo
Dec
14
comment Design database to query a date range for scheduling
Indexes, you are right I'll let dbms do the work. Yes a column will be updated for that purpose, thanks
Dec
14
comment Design database to query a date range for scheduling
@ypercube it depends, on the first approach the table will contain id's and date ranges, etc, for same id (because there are multiple ranges for every id) so ranges will not overlap, but of course they will overlap for different id's. In the second approach they will not overlap by design because the idea is to identify (on insert) if the range was already used (slow insert) and assign a unique id for that range to reuse in the first table.
Dec
14
asked Design database to query a date range for scheduling
Dec
14
awarded  Supporter