diff options
| author | Jeremy Kersten <jke@odoo.com> | 2020-09-18 13:00:03 +0000 |
|---|---|---|
| committer | Jeremy Kersten <jke@odoo.com> | 2020-09-18 13:08:20 +0000 |
| commit | 86f065e3571a1339798501156804fda6c57c6989 (patch) | |
| tree | adb598939392be936a61d4be96e65fc9adba2a73 | |
| parent | 0c55a951fe7f38edb2d2c53736cc7a97d1d4432f (diff) | |
[IMP] website_blog: tour query count improvement
Disabled livechat in blog query count
if website_livechat is installed before website_blog, the get_livechat_channel_info add
unrelated query for the current test. So we disabled it.
Courstesy of @Xavier-Do for analyse
closes odoo/odoo#58034
Signed-off-by: Xavier Dollé (xdo) <xdo@odoo.com>
| -rw-r--r-- | addons/website_blog/tests/test_performance.py | 16 |
1 files changed, 11 insertions, 5 deletions
diff --git a/addons/website_blog/tests/test_performance.py b/addons/website_blog/tests/test_performance.py index 4a472fd8236..9a9c7e877c0 100644 --- a/addons/website_blog/tests/test_performance.py +++ b/addons/website_blog/tests/test_performance.py @@ -6,8 +6,14 @@ import random class TestBlogPerformance(UtilPerf): + def setUp(self): + super().setUp() + # if website_livechat is installed, disable it + if 'channel_id' in self.env['website']: + self.env['website'].search([]).channel_id = False + def test_10_perf_sql_blog_standard_data(self): - self.assertEqual(self._get_url_hot_query('/blog'), 32) + self.assertEqual(self._get_url_hot_query('/blog'), 28) def test_20_perf_sql_blog_bigger_data_scaling(self): BlogPost = self.env['blog.post'] @@ -19,8 +25,8 @@ class TestBlogPerformance(UtilPerf): for blog_post in blog_posts: blog_post.tag_ids += blog_tags blog_tags = blog_tags[:-1] - self.assertEqual(self._get_url_hot_query('/blog'), 32) - self.assertEqual(self._get_url_hot_query(blog_post[0].website_url), 35) + self.assertEqual(self._get_url_hot_query('/blog'), 28) + self.assertEqual(self._get_url_hot_query(blog_post[0].website_url), 31) def test_30_perf_sql_blog_bigger_data_scaling(self): BlogPost = self.env['blog.post'] @@ -32,5 +38,5 @@ class TestBlogPerformance(UtilPerf): for blog_post in blog_posts: blog_post.write({'tag_ids': [[6, 0, random.choices(blog_tags.ids, k=random.randint(0, len(blog_tags)))]]}) - self.assertLessEqual(self._get_url_hot_query('/blog'), 32) - self.assertLessEqual(self._get_url_hot_query(blog_post[0].website_url), 35) + self.assertLessEqual(self._get_url_hot_query('/blog'), 28) + self.assertLessEqual(self._get_url_hot_query(blog_post[0].website_url), 31) |