Changes between Version 233 and Version 234 of DatabaseBasedAnalysis/Spectrum


Ignore:
Timestamp:
12/09/19 18:19:04 (5 years ago)
Author:
tbretz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DatabaseBasedAnalysis/Spectrum

    v233 v234  
    113113== Get Data File List ==
    114114
     115{{{#!Spoiler
     116{{{#!sql
     117        "CREATE TEMPORARY TABLE DataFiles\n"
     118        "(\n"
     119        "   FileId INT UNSIGNED NOT NULL,\n"
     120        "   PRIMARY KEY (FileId) USING HASH\n"
     121        ") ENGINE=Memory\n"
     122        "AS\n"
     123        "(\n"
     124        "   SELECT\n"
     125        "      FileId\n"
     126        "   FROM\n"
     127        "      factdata.RunInfo\n"
     128        "   WHERE\n"
     129        "      %0:where\n"
     130        "   ORDER BY\n"
     131        "      FileId\n"  // In order: faster
     132        ")";
     133}}}
     134}}}
     135
    115136== Get Observation Time ==
    116137