[TYPO3-dev] RFC: Change roadmap for 4.5 and 5.0

Dimitri Tarassenko mitka at mitka.us
Tue Apr 11 16:07:04 CEST 2006


Elmar,

> You want to store also the weekdays into the DB, although they could be
> evaluated from the date?

Huh? Where did I say that? What I meant is

select * from a where dayofweek(d)=3               (1)

going to be faster than

select * from a where dayofweek(from_unixtime(d))=3    (2)

What's more important, is that in most SQL dialects you would have to
implement from_unixtime(x) as dateadd() or + interval expression.

> Hmm, interesting idear for a quicker search.

Indeed. I would've never imagined something like that ;))))

--
Dimitri Tarassenko


More information about the TYPO3-dev mailing list