Hello,
We have got an applications where we query about 50 types of snmp OIDs. The types of OIDs are drops into several types such as integer, double, date, string and float.

We are planning a structure to keep type information in a different table and keep the data in single column in a different table. Our aim is to build an architecture flexible to be able to add new OIDs in future.

Some of the OID needs to be pulled a lot more than the others.

Our question is what will be the performance figures as oppose solution. The oppose solution would be to have each OID in a table column with its type known.

I hope description is enough for you to see the problem.

Regards

probably best to ask this in the concepts section

Usually it helps to give an indication of the target platform if known