patjdixon Posted September 22, 2023 Posted September 22, 2023 (edited) I am pushing 8 worksheets to a workbook and it is taking nearly 3 hours. I notice the count is 321. Is that what it thinks the number of worksheets is, or is it items, or something else? Regardless, this is a much higher number than I think it should be, which might explain why it is taking so long. Edited September 22, 2023 by patjdixon
Seeq Team Mark Derbecker Posted September 22, 2023 Seeq Team Posted September 22, 2023 That's the number of unique items, and it includes lots of things: - Worksheets - Worksteps (these are the individual worksheet "states" that define the displayed items and all other worksheet configuration at a particular point in time) - Calculated items (signals/conditions/scalars/metrics/histograms) -- this referred to as the "item inventory" - Journal text - Journal images The things that generally take a long time are the Calculated items. You can try specifying `include_inventory=False` during your push to see if that's a lot faster. 1
Solution patjdixon Posted November 1, 2023 Author Solution Posted November 1, 2023 Setting include_inventory and refresh false dramatically reduced the time, Emilio helped me with this: spy.workbooks.push(WorkbookInstance, include_inventory=False, refresh = False)
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now