Custom Columns question

Unanswered Question
Mar 23rd, 2009

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.

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Farrukh Haroon Mon, 03/23/2009 - 13:04

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

Regards

Farrukh

Actions

This Discussion