Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How efficient is storage of complex types?

Deb_ChatignyDeb_Chatigny Administrator
edited April 2020 in General Discussion

How efficiently are the complex types physically stored (encoding, storage footprint, CPU/memory consumption when working with them)?

Question asked by an attendee during Putting Complex Data Types to Work. @DeepakMajeti @rroelke


  • ChuckBChuckB Employee

    Vague question... but basically, as efficient as a deconstructed set of primitive types, if you use the new CT stuff (So... extremely efficient!). Sometimes inefficient, if you use unoptimized flex maps.

  • mcelliomcellio Employee

    FYI, one-dimensional arrays are the only complex types that can currently be stored in ROS data; everything else is external tables.

  • What encoding can be used in case of the new CT stuff?

  • edited November 2021

    The main thing to consider is the CPU/memory consumption when working with them. The CPU time consumed when dealing with complex type will depends on the number of values of that type in your document. The more complex data types you use, the more CPU time will be consumed. Hightechreviewer The more values of that type in your document, the more memory space will be consumed. So, if your document contains millions of complex type values, you should be extremely careful about using them. You can get an estimate of the amount of CPU time and memory space of your document using the Numbers. Nonstoptechno Numbers.getN() method.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.