Where can I find the size of my eSpaces?

Where can I find the size of my eSpaces?

  

In the best practices I see that: An eSpace with a size > 4Mb normally means bad architecture

I can see the total size of everything in my personal environment and I can download my eSpace and see the size of the oml file, but can I see a list of the sizes of my eSpaces somewhere?

Thanks for you help.


Jaacov


Hi Jaacov,

I think you need to create solution for that, Go to service center-->Factory-->Solutions-->New Solutions. It will give you OSP file. The OSP file is a solution that contain eSpaces and components. Here you can check the size of your Module. 


-Hitesh

Solution

Alternatively, just save it to disk (press Ctrl-S or via Module -> Export -> Save) and check there.

Solution

Hi,


I would suggest to download the espace and check the size of *.OAP.


Thanks!

Ok all, thanks a lot for your help!


Hello,

If you want to do it programmatically you can:

1. Include dependencies Espace_Version and Espace from System

2. Do a query like this example


3. Do something with the binary data size(Espace_Version.OML_File)


If you want to do it by SQL server you can do it like this:

SELECT SUM(DATALENGTH(OML_File)) / 1048576.0
FROM ossys_espace_version
WHERE ID = XYZ

This will return the OML size in MB.

mmenezes wrote:

Hello,

If you want to do it programmatically you can:

1. Include dependencies Espace_Version and Espace from System

2. Do a query like this example


3. Do something with the binary data size(Espace_Version.OML_File)


If you want to do it by SQL server you can do it like this:

SELECT SUM(DATALENGTH(OML_File)) / 1048576.0
FROM ossys_espace_version
WHERE ID = XYZ

This will return the OML size in MB.

Nicely done Márcio :)