More ways to query the contents of the blend file.
I downloaded a very simple file with 2 low poly objects. The file is 4mb. I downloaded another file with a whole mobile game character, rigged, animated, packed textures, multiple environments, and other things. The file size is 4mb.
I would like a way to see the file size contribution of every data block.
I have a scene with not that many objects, most are low poly, 2 are high poly, 8 are medium poly with a subdiv modifier. The BVH updating step before the actual render starts takes MUCH longer than then actual render. Also the Mr Elephant (mouse in front of a fireplace) demo scene is like this.
I wish there was something that would tell me which objects or modifiers are causing the time taken in the BVH stuff.
I need a way to find all objects with a bevel modifier and all with a bevel modifier that is active in the viewport but inactive in the render.
I need a way to find all objects of type point light whose name does not contain the text "point".
I need a way to find all objects that have camera visibility unticked.
I need a way to find all lights with a negative strength value.
I need a way to find all objects that are in more than 1 collection.
I need a way to find all materials that contain an emission shader node.
I need a way to find all objects that have only 1 child and are themselves the child of another object.
Basically I need a utility that will read a .blend file and extract almost all the data possible and dump it into an sql database so I can easily run useful queries on the data with inner joins and outer joins and left and right joins and basically any question I might want to ask I could easily answer.
Which scene has the most polygons? Which collection has the most polygons? Which object has the most polygons?
3 Comments
Maybe more enhancement about statistic like in windirstat.net/
blender.community/c/rightclickselect/x0hbbc/ Outliner - more precision for statistic information
yes but how do you propose to solve it? you've listed a bunch of things you need to query for, and they are all fairly niche- can't exactly have a context menu full of those things now can we? I would also argue that Blender already has a very reliable way to construct any type of query you can think of, just have to learn some very rudimentary python and understand how the bpy data is stored- you really do not need to be a programmer to be able to make a script that simple.
There are huge advantages to actually having the data in a sql database. If I did write a script it would be to gather all the information and dump it to a file I could import into sql and then I'd run my queries there.
I suspect something like sqlite might already be used within Blender for some things and if that is the case then my idea could be built on top of that.
write query code in the text editor, right click that play triangle button, run as sql query, output shown in console