I have recently started developing basic tools in .Net to help analyse data.
My background is mostly working with vba and I think some habbits from excel macros have began impacting the speed of some of these tools.
My current project follows a rough logic as set out below
Start with predefined AFElements list [A].
Cycle through this list[A] (For each) to get next level of elements[B]
Cycle through each of the elements [B] (For each) and look at their attributes [C].
Each element in B has >100 Attributes. I am interested in 3 of these attributes which will always either have the same name or will not exist.
For each of the 3 attributes of interest I do an AFValues function
AFValues attributeValues = MyAttribute.GetValues(afTimeRange, 0, null);
which gets data over a 24 hour period of interest.
I then cycle through the results to find particualt key events using functions.
There are some problems wioth the way this is done that I know of and I am hoping I can fix
- Cycling through 100 attributes for 3 known names seems redundant, I am quite sure I should be able to set them somehow.
- I think there should be a way to query all 3 attributes at once to make things slightly faster?
- And again If i am cycling through all element and looking for the same 3 attributes I think I should be able to query those at once as well.
Any help on this would be great.
My search through some preious questions in a similar area left me rather confused.