diff options
| author | Greg Roach <fisharebest@webtrees.net> | 2019-03-03 18:44:02 +0000 |
|---|---|---|
| committer | Greg Roach <fisharebest@webtrees.net> | 2019-03-03 18:44:02 +0000 |
| commit | 18e9654e776d817224b6f769b1bf65d4cef974d6 (patch) | |
| tree | 296ea1565b0927d3794af947570206cd25fb36b3 | |
| parent | 4459dc9a6d0c27769f8135175f3569e4fa287451 (diff) | |
| download | webtrees-18e9654e776d817224b6f769b1bf65d4cef974d6.tar.gz webtrees-18e9654e776d817224b6f769b1bf65d4cef974d6.tar.bz2 webtrees-18e9654e776d817224b6f769b1bf65d4cef974d6.zip | |
#2296 - improve performance of first-marriage-month query
| -rw-r--r-- | app/Statistics/Repository/FamilyRepository.php | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/app/Statistics/Repository/FamilyRepository.php b/app/Statistics/Repository/FamilyRepository.php index 3e4a869e8b..0893bc5fec 100644 --- a/app/Statistics/Repository/FamilyRepository.php +++ b/app/Statistics/Repository/FamilyRepository.php @@ -1680,6 +1680,7 @@ class FamilyRepository ->on('d_gid', '=', 'f_id') ->on('d_file', '=', 'f_file') ->where('d_fact', '=', 'MARR') + ->whereIn('d_month', ['JAN', 'FEB', 'MAR', 'APR', 'MAY', 'JUN', 'JUL', 'AUG', 'SEP', 'OCT', 'NOV', 'DEC']) ->where('d_julianday2', '<>', 0); })->join('individuals', function (JoinClause $join): void { $join |