Re: Find between a list of values
From: Jerry Stuckle <jstucklex_at_attglobal.net>
Date: Sun, 1 Apr 2018 22:07:33 -0400
Message-ID: <p9s396$1vq$1_at_jstuckle.eternal-september.org>
>
> Sure, and where i can, i've started to normalize the database.
> But that's not easy but is what I'm already using with already normalized tables.
>
>
> I've asked here thinking about a workaround, to speed up lookups on existing tables planned for a future refactor.
>
Date: Sun, 1 Apr 2018 22:07:33 -0400
Message-ID: <p9s396$1vq$1_at_jstuckle.eternal-september.org>
On 4/1/2018 1:01 PM, gandalf.corvotempesta_at_gmail.com wrote:
> Il giorno sabato 31 marzo 2018 14:40:13 UTC+2, Jerry Stuckle ha scritto:
>> The first thing you need to do is normalize your database. One value >> per row/column. If I read this properly, you should have a second table >> linked to the first with three columns - id of the first table row, >> start and stop. You may add a fourth column for a unique id of the row.
>
> Sure, and where i can, i've started to normalize the database.
> But that's not easy but is what I'm already using with already normalized tables.
>
>
> I've asked here thinking about a workaround, to speed up lookups on existing tables planned for a future refactor.
>
If you're storing start and stop in the same filed - and especially if you have multiple ones - you do not have a normalized database. It fails first normal form.
There is no "workaround" for such a problem other than proper database design.
-- ================== Remove the "x" from my email address Jerry Stuckle jstucklex_at_attglobal.net ==================Received on Mon Apr 02 2018 - 04:07:33 CEST