#filesize

Uzak Sunucu Dosya İstatiktikleri Sınıfı

Have some large pdfs in your dev sitecore instance that are slowing down publish and indexing tasks? Here is some SQL to help you find the culprits.

First create this Function in SQL Server on your Sitecore instances Master database: https://gist.github.com/blacktambourine/85164facde52b144e253f5c31bc28563

This allows you to query for a particular field of an item.

Now you can get the Filesize of all items in your database with this SQL query:

Thanks to this article for doing the hard part:

While learning Unreal Engine 4 I was tasked to create an Exterior Arch viz scene to try and figure out what results we’d get if we were to use it for Rendering animations faster. Originally I was just planning on having the animation completely silent, but I decided to add audio as it would give it a more realistic feel.

All I did was add a loop of birds chirping as I thought it would make sense as It’s an outdoor scene.

While importing the jpeg sequence from unreal into premier I came into the issue of it importing as 25 fps which isn’t right as it would almost doubles the animation time, which isn’t right as I recorded in 60fps to give it a smooth feel rather than the traditional 25 fps animation. to fix this I just forced the sequence to be 60 fps by right clicking it.

The File size isn’t actually as big as I expected,  It’s 30MB which is really low compared to the jpeg sequence which was around 1.35GB due to the amount of Jpeg images, and their file size.