PeteWright
Active Member
- Joined
- Dec 20, 2020
- Messages
- 421
- Office Version
- 365
- Platform
- Windows
- Mobile
Hello!
As the topic title says I need to manage a big amount of data and I'm not sure what method has the best performance.
Some information on what I deal with:
I have points with geographic coordinates and some attributes which are stored in a text file at the beginning and then imported into an Excel Sheet via VBA on user button click.
Let's assume we have 9.999 points which have 6 properties (Point no, Easting, Northing, Height, Attribute1, Attribute2).
That makes about 60.000 Excel cells.
Now all data is stored in an Excel Sheet, but this makes the handling a little uncomfortable (e.g. selecting by cell reference not by index, etc.)
In order to have more control (e.g. count, sort, reorder, remove, duplicate, etc.) over the points, I would like to store them in an multidimensional array.
I already have a user defined data type:
Is this the way to go or are there better methods to store the data?
How about the performance of multidimensional Arrays with lot of data?
What if the number of points increases by ten times to 99.999 points?
Any help appreciated
As the topic title says I need to manage a big amount of data and I'm not sure what method has the best performance.
Some information on what I deal with:
I have points with geographic coordinates and some attributes which are stored in a text file at the beginning and then imported into an Excel Sheet via VBA on user button click.
Let's assume we have 9.999 points which have 6 properties (Point no, Easting, Northing, Height, Attribute1, Attribute2).
That makes about 60.000 Excel cells.
Now all data is stored in an Excel Sheet, but this makes the handling a little uncomfortable (e.g. selecting by cell reference not by index, etc.)
In order to have more control (e.g. count, sort, reorder, remove, duplicate, etc.) over the points, I would like to store them in an multidimensional array.
I already have a user defined data type:
VBA Code:
Private Type Point
n as Integer
y As Double
x As Double
z As Double
a1 As String
a2 As String
End Type
Dim P1001 As Point
P.n = 1001
P.x = 4567890.123
P.y = 3456789.012
P.z = 123.456
P.a1 = "Zone 1"
P.a2 = "Category 2"
Is this the way to go or are there better methods to store the data?
How about the performance of multidimensional Arrays with lot of data?
What if the number of points increases by ten times to 99.999 points?
Any help appreciated
Last edited: