Changes between Version 1 and Version 4 of Ticket #1658


Ignore:
Timestamp:
Sep 8, 2012, 10:06:51 PM (6 years ago)
Author:
tobixen
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #1658

    • Property Component changed from unknown to BW General
    • Property Type changed from unknown to improve feature
    • Property Summary changed from updatestats.php - change some SQL to updatestats.php - change some SQL (trivial!)
  • Ticket #1658 – Description

    v1 v4  
    55}}}
    66
    7 I created an index on BW_ARCH.logs(created), but it didn't help.  Looking at the query again, I notice that the join to the members table is probably a noop and can be dropped:
     7I created an index on BW_ARCH.logs(created), but it didn't help.  Looking at the query again, I notice that the join to the members table is a noop and can be dropped.  I ran the old query and the query without the join - they return the same, but it's very much faster without the join:
    88
    99{{{