diff options
| author | Greg Roach <fisharebest@webtrees.net> | 2019-03-03 19:02:13 +0000 |
|---|---|---|
| committer | Greg Roach <fisharebest@webtrees.net> | 2019-03-03 19:02:13 +0000 |
| commit | 25e6882f384fba8dfce6d347d3fbd3f1d24e8cff (patch) | |
| tree | d9cc4cc0ab05bdb2a5dea40637c116732217aa81 | |
| parent | 18e9654e776d817224b6f769b1bf65d4cef974d6 (diff) | |
| download | webtrees-25e6882f384fba8dfce6d347d3fbd3f1d24e8cff.tar.gz webtrees-25e6882f384fba8dfce6d347d3fbd3f1d24e8cff.tar.bz2 webtrees-25e6882f384fba8dfce6d347d3fbd3f1d24e8cff.zip | |
#2296 - improve performance of first-marriage-month query
| -rw-r--r-- | app/Statistics/Repository/FamilyRepository.php | 5 |
1 files changed, 1 insertions, 4 deletions
diff --git a/app/Statistics/Repository/FamilyRepository.php b/app/Statistics/Repository/FamilyRepository.php index 0893bc5fec..dc17e979d3 100644 --- a/app/Statistics/Repository/FamilyRepository.php +++ b/app/Statistics/Repository/FamilyRepository.php @@ -1698,10 +1698,7 @@ class FamilyRepository } return $query - ->select(['f_id AS fams', 'f_husb', 'f_wife', 'd_julianday2 AS age', 'd_month AS month', 'i_id AS indi']) - ->orderBy('f_id') - ->orderBy('i_id') - ->orderBy('d_julianday2'); + ->select(['f_id AS fams', 'f_husb', 'f_wife', 'd_julianday2 AS age', 'd_month AS month', 'i_id AS indi']); } /** |