)]}'
{"ceilometer/storage/impl_sqlalchemy.py":[{"author":{"_account_id":6537,"name":"gordon chung","email":"gord@live.ca","username":"chungg"},"change_message_id":"c60595377d13fcc8a2170139c59695f91f2eb58b","unresolved":false,"context_lines":[{"line_number":544,"context_line":"        # using meter table sub-select limits the table scan"},{"line_number":545,"context_line":"        # on the sample table when only a limit number of"},{"line_number":546,"context_line":"        # samples are needed."},{"line_number":547,"context_line":"        if sample_filter.meter and limit:"},{"line_number":548,"context_line":"            subq \u003d session.query(models.Meter.id,"},{"line_number":549,"context_line":"                                 models.Meter.type,"},{"line_number":550,"context_line":"                                 models.Meter.name,"}],"source_content_type":"text/x-python","patch_set":3,"id":"3a961159_37141a4c","line":547,"updated":"2014-12-22 15:14:57.000000000","message":"why is limit important here if it\u0027s not used in the subquery part of execution?","commit_id":"45e4981136b3af34e0f664642a87e7ae2788f413"},{"author":{"_account_id":13560,"name":"Rohit Jaiswal","email":"rohit.jaiswal@gmail.com","username":"rjaiswal"},"change_message_id":"c2f2dd9325102ebc37cbb762307ed2f6da6e81c4","unresolved":false,"context_lines":[{"line_number":544,"context_line":"        # using meter table sub-select limits the table scan"},{"line_number":545,"context_line":"        # on the sample table when only a limit number of"},{"line_number":546,"context_line":"        # samples are needed."},{"line_number":547,"context_line":"        if sample_filter.meter and limit:"},{"line_number":548,"context_line":"            subq \u003d session.query(models.Meter.id,"},{"line_number":549,"context_line":"                                 models.Meter.type,"},{"line_number":550,"context_line":"                                 models.Meter.name,"}],"source_content_type":"text/x-python","patch_set":3,"id":"3a961159_e633b85f","line":547,"in_reply_to":"3a961159_37141a4c","updated":"2014-12-24 17:37:28.000000000","message":"When a limit number of samples are requested, there is better control over the number of rows scanned in sample table with the sub-select on meter table. The mysql explain plans provided the proof of this.","commit_id":"45e4981136b3af34e0f664642a87e7ae2788f413"}]}