List:General Discussion« Previous MessageNext Message »
From:Perrin Harkins Date:April 22 2008 6:21pm
Subject:Re: Performance
View as plain text  
On Tue, Apr 22, 2008 at 11:41 AM, Bruno B.  B.  Magalhães
<brunomagalhaes@stripped> wrote:
> I thing
> the most problematic part of those queries are the date range part, should I
> use a different index only for this column to maintain the index small?

My experience with doing data warehousing in MySQL was that when all
you need is day granularity, you are much better off having a
de-normalized 'days_since_epoch' column or a date dimension table with
a column like that.  Then your date math becomes simple integer
comparisons which are much faster.

- Perrin
Thread
auto_incrementHiep Nguyen21 Apr
  • Re: auto_incrementSebastian Mendel22 Apr
    • Re: auto_incrementSebastian Mendel22 Apr
      • Re: auto_incrementHiep Nguyen22 Apr
  • Re: auto_incrementBen Clewett22 Apr
    • Re: auto_incrementSebastian Mendel22 Apr
      • Re: auto_incrementBen Clewett22 Apr
      • PerformanceBruno B .  B .  Magalhães22 Apr
        • Re: PerformancePhil22 Apr
        • Re: PerformanceRob Wultsch22 Apr
        • Re: PerformanceRob Wultsch22 Apr
        • Re: PerformancePerrin Harkins22 Apr
          • Re: PerformanceBruno B .  B .  Magalhães22 Apr
            • Re: PerformanceRob Wultsch22 Apr