It is currently Thu Aug 21, 2014 7:56 pm




Post new topic Reply to topic  [ 4 posts ] 
 get window storage size 
Author Message
General
General

Joined: Thu Jul 31, 2008 2:08 pm
Posts: 386
Location: Chico, CA
Post get window storage size
I am setting up a system for inventorying all our project windows. I have it setup to log the project name,window name, and last opened date/time.

Is there a way to get the storage size of a window in a project?

I thought this might be useful for finding windows that have huge datasets in them. This would help us keep our project size down.

Thank you,

_________________
Jonathan


Fri Jun 08, 2012 10:56 am
Profile
Moderator
Moderator

Joined: Fri Mar 16, 2012 1:00 pm
Posts: 903
Location: Sacramento, CA
Post Re: get window storage size
No, there isn't anyway for you to currently do that.

_________________
Greg Simpson
Inductive Automation
Technical Support Rep


Fri Jun 08, 2012 10:59 am
Profile
General
General

Joined: Tue Feb 24, 2009 1:30 pm
Posts: 891
Location: Calgary
Post Re: get window storage size
A bit manual, serialize it in the designer. This would give you a relative size. Anything over a certain amount or if it suddenly jumped it size could a red flag to look deeper at the serialized XML.


Mon Jun 11, 2012 11:51 am
Profile WWW
Moderator
Moderator

Joined: Sun Apr 02, 2006 2:46 pm
Posts: 4049
Location: Sacramento, CA
Post Re: get window storage size
If you SHIFT-Right-click on a window, you can see the window's size under the Window Info entry.

Or in the raw settings viewer, this query will give you your window sizes.
SELECT name AS Window_Name,
bit_length(data)/1024.0 AS Window_Size
FROM project_resources
WHERE resourcetype='window'


Obviously, use the raw settings viewer with EXTREME caution. If you mess up your system, you won't get any sympathy from the techs over the phone.

_________________
Carl Gould
Co-Director, Software Engineering
Inductive Automation


Thu Jun 14, 2012 9:29 am
Profile WWW
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron