PacketFence
Bug Tracking System

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000863PacketFencepublic2009-11-30 15:052011-01-26 15:39
Reporterobilodeau 
Assigned Torbalzard 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version1.9.0 
Summary0000863: web admin's node tab is slow when there are a lot of nodes
Descriptionmy guess is that each node does a subselect and that's why its so long.

$node_view_all_sql
        = "select node.mac,node.pid,node.detect_date,node.regdate,node.unregdate,node.lastskip,node.status,node.user_agent,node.computername,node.notes,node.last_arp,node.last_dhcp,node.dhcp_fingerprint,node.switch,node.port,node.vlan,ifnull(openviolations.nb,0) as nbopenviolations from node left join (select violation.mac,count(*) as nb from violation where status='open' group by violation.mac) as openviolations on node.mac=openviolations.mac";

the idea here is, should we limit the query to what we can see on the screen or should we optimize it?
TagsNo tags attached.
fixed in git revision
fixed in mtn revisiondf864b7289b1596a82abbfba30b3eee2688944b7
Attached Files

- Relationships

-  Notes
(0001496)
obilodeau (reporter)
2010-03-15 17:11

Fixed by Regis in branch 1.8.

The problem was not missing limit clauses, they are appended automatically. The problem was in the subselect. Regis found a way to avoid subselect with grouping and using having instead of where clauses.

- Issue History
Date Modified Username Field Change
2009-11-30 15:05 obilodeau New Issue
2009-11-30 15:05 obilodeau Status new => assigned
2009-11-30 15:05 obilodeau Assigned To => obilodeau
2010-03-15 17:11 obilodeau mtn revision => df864b7289b1596a82abbfba30b3eee2688944b7
2010-03-15 17:11 obilodeau Note Added: 0001496
2010-03-15 17:11 obilodeau Assigned To obilodeau => rbalzard
2010-03-15 17:11 obilodeau Status assigned => resolved
2010-03-15 17:11 obilodeau Resolution open => fixed
2010-03-15 17:11 obilodeau Fixed in Version => 1.8.8
2010-04-29 13:38 obilodeau Fixed in Version 1.8.8 => 1.9.0
2011-01-26 15:39 obilodeau Status resolved => closed


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker