[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