Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #25361 All Revisions ] Back to Issue ]
Summary 0025361: Unneeded queries when filtering
Revision 2013-12-18 08:37 by alostale
Description Whenever a filter on a foreign key is applied in a grid AD is queried to determine whether the identifier is composed by one or more columns.

This results in DB 3 queries (one to get column, one to get table and another one to get all columns in table) and in a loop over all columns in table.

Note these queries are repeated for each FK field that is used in the filter.
Revision 2013-12-18 08:36 by alostale
Description Whenever a filter on a foreign key is applied in a grid AD is queried to determine whether the identifier is composed by one or more columns.

This results in DB 3 queries (one to get column, one to get table and another one to get all columns in table) and in a loop over all columns in table.


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker