mysql 5 new install help requested

2009-01-29 Thread lance raymond
Man, the forums are good, but lists are just so much easier! Anyway, I left post unanswered now and I need to get this problem solved, so I am hoping this list is more direct. Basically a fc5/mysql4 server is having hard drive errors. We had a slightly newer/faster server, so I staged it with ce

Re: Are dates stored as String? Or Integer?

2009-01-29 Thread Martijn Tonies
Are date columns stored as String or Integer in a MyISAM table? I am trying to squeeze more speed from my application and a date column is used in most of the indexes for my tables. I'm wondering if changing the Date data type to an Integer is going to speed the queries up. I'm using Delphi

Re: TIME variable issue

2009-01-29 Thread Martijn Tonies
We are using TIME for calculating SLA and this sometimes involves a years time to hold in the time variable. Please suggest an alternative. Define a proper "interval"-like construct?? TIME should be used for "time of day", even though MySQL supports storing more in it, doesn't mean it's a goo

TIME variable issue

2009-01-29 Thread Ajit Tirumalasetti
We are using TIME for calculating SLA and this sometimes involves a years time to hold in the time variable. Please suggest an alternative.   Thanks!! Ajit Tirumalasetti ajit.tirumalase...@yahoo.co.uk