Batch discussion ratings queries

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 6.0.2 RC
• Fix Version/s: 6.0.3 GA, 6.0.4 GA
• Component/s: Operations > Performance
• Labels: None
• Similar Issues: Show 5 results ; ;

  LPS-6909	Errors with star rating system
  LPS-25700	Error on search portlet when using solr and the resulting query is too long
  LPS-22742	Queries created by AssetEntryFinderImpl not working with PostgreSQL
  LPS-26223	Performance improvement of the query used to retrieve the users for indexing
  LPS-4071	JDBCExceptionReporter:101] failed batch

Discussion taglib uses ratings queries a lot, to improve performance i group a batch of small ratings related queries into a big one.

[Jonas Yuan]

Hi Shuyang, Thanks.

It may cause another issue: LPS-10218. It would be nice that you could double check.

Thanks

Jonas Yuan