Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010

    table and column organization for snmp OIDs

    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.


  2. #2
    Join Date
    Nov 2004
    out on a limb
    probably best to ask this in the concepts section

    Usually it helps to give an indication of the target platform if known
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts