My DocMeta table has 50 columns. we are building lots of applications in UCM. Every application has its own meta-data requirements. I doubt that pretty soon the column count will increase to 100+. Is there any limitation in UCM on number of custom meta-data fields that we can create? if my DocMeta columns count increases to 100, would it affect the queries/UCM performance ?
It would depend on the underlying database from a technical standpoint.
A good discussion for Oracle database limits - Limit on a number of columns in a table?
MS SQLServer - http://msdn.microsoft.com/en-us/library/ms143432.aspx
From a usability/maintenance standpoint, that's another matter. YMMV.