Custom Columns question

Unanswered Question
Mar 23rd, 2009
User Badges:
  • Bronze, 100 points or more

I run a LOT of "All Matching Sessions, Custom Column" queries, since they let me more quickly see the Host Pairs involved with an incident (and/or to see ALL of the host pairs matching certain criteria)

Anyways, there are two options for having a column on Destination Address. The first is the Dest. Address all by itself, so if you wanted Port and/or Protocol you'd have to explicitly request them. The other option is a single field "Destination Address, Port, and Protocol" (e.g. the results are grouped together.)

My questions is: which field type is more efficient from a MARS SQL query perspective? In other words, is it faster to split the fields out (e.g. one field for Destination Address, another field for Destination Port) or is it faster to have them a single, combined field.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Farrukh Haroon Mon, 03/23/2009 - 13:04
User Badges:
  • Red, 2250 points or more

Why don't you try both of them out (for the same traffic flows/time period) and then compare the query response times?




This Discussion