[mythtv] database schema

[Mike Javorski]

Actually, I CAN get actual original dates, but whatever..

In what sense are you speaking of "strings". Do you mean for
titles,series and things of that nature? if so there is the problem of
standardization.. the ideal thing to do would be to have each series
have an official "number" and do everything numerically (this is how
TiVo manages everything, with numerical record ID's). This is NOT a
small task though, and would take some creative coordination..

- Mike

On Sat, 2003-03-15 at 23:08, Andy Davidoff wrote:
> Original airdates are only available as years and are currently stored as such.
> 
> The size issue has consistently been shrugged off, but what I would rather look
> at is the use of fixed-length records.  If we moved strings out of the program
> table, many queries would run much faster.  This may not seem like an issue when
> you only have 60 channels and only keep a week of program data in your DB, but
> when you have multiple inputs, each with several hundred channels and a month of
> future program data, interactivity suffers.
> 
> Also, we've verified that MySQL 3.23.54a doesn't optimize some queries well
> enough for them to run with decent interactivity, while 3.23.55 does fine.
> I really think that version 3.23.55 should be made a requirement, or at least
> a recommendation.  Especially in light of the fact that patches to resolve
> these differences have been rejected.
> 
> Thanks for offering to fix the TIMESTAMPs...
> 
> 
> #if Mike Javorski /* Mar 15, 22:44 */
> >  - TIMESTAMP is limited to POST 1970 & PRE 2037 dates. Granted the 2037
> > limit isn't an issue, but if we were to (eventually) indicate things
> > like original air date of a show (such as Dick Van Dyke or Scooby-Doo,
> > both of which were made in the 60's), the system would go foo-bar on the
> > dates.
> > 
> > - As far as size is concerned, its really at the "microscopic level" in
> > this instance.. I mean 8 BYTES vs. 4. We aren't talking a HUGE deal
> > (considering most of us run machines with more than enough space).
> #endif /* mikej at carmelfly.com */
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at snowman.net
> http://www.snowman.net/mailman/listinfo/mythtv-dev