Project

General

Profile

Bug #64251

Speed up pool.query for hundreds of datasets

Added by Bug Clerk almost 3 years ago. Updated over 2 years ago.

Status:
Done
Priority:
No priority
Assignee:
William Grzybowski
Category:
Middleware
Target version:
Seen in:
Severity:
New
Reason for Closing:
Reason for Blocked:
Needs QA:
No
Needs Doc:
No
Needs Merging:
No
Needs Automation:
No
Support Suite Ticket:
n/a
Hardware Configuration:
ChangeLog Required:
No

Description

Bonnie noticed on her test machine that pool listings take a long time to complete on pages like manual update. It appears that pool.query is taking a while to finish which is causing the problem.


Related issues

Copied from FreeNAS - Bug #60759: pool.query takes a few seconds to complete when there are 500 datasetsDone

History

#1 Updated by Bug Clerk almost 3 years ago

  • Copied from Bug #60759: pool.query takes a few seconds to complete when there are 500 datasets added

#2 Updated by Bug Clerk almost 3 years ago

  • Target version changed from Master - FreeNAS Nightlies to 11.2-U2

#3 Updated by Bug Clerk almost 3 years ago

  • Status changed from Unscreened to In Progress

#4 Updated by Bug Clerk almost 3 years ago

  • Status changed from In Progress to Ready for Testing

#5 Updated by Dru Lavigne almost 3 years ago

  • Subject changed from pool.query takes a few seconds to complete when there are 500 datasets to Speed up pool.query for hundreds of datasets
  • Needs Doc changed from Yes to No
  • Needs Merging changed from Yes to No

#6 Updated by William Grzybowski almost 3 years ago

Acceptance Criteria
Have a big number of datasets (e.g. 300-500) and run
  1. time midclt call pool.query

And make sure that does not take several seconds

#8 Updated by Bonnie Follweiler over 2 years ago

  • Status changed from Ready for Testing to Passed Testing
  • Needs QA changed from Yes to No

Test Passed in FreeNAS-11.2-INTERNAL72

#9 Updated by Dru Lavigne over 2 years ago

  • Status changed from Passed Testing to Done

Also available in: Atom PDF