Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strings
Does anyone know if there is a large overhead in declaring a variable
length string (which could hold up to 2^31 characters) over a fixed length string? I assume the memory gets allocated on the fly as 2^31 bytes = 2 GIG, and I only have half a gig of memory. I need to declare some pretty huge arrays of strings and need to know up front if I am going to run out of memory or not I appreciate I'd have to implement my own terminator and length function like in C. My strings will typically be 16 characters long, but could go up to say 35 characters long -- Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strings
On Sun, 12 Jun 2005 11:33:54 +0100, Mike NG wrote:
Does anyone know if there is a large overhead in declaring a variable length string (which could hold up to 2^31 characters) over a fixed length string? I assume the memory gets allocated on the fly as 2^31 bytes = 2 GIG, and I only have half a gig of memory. I need to declare some pretty huge arrays of strings and need to know up front if I am going to run out of memory or not I appreciate I'd have to implement my own terminator and length function like in C. My strings will typically be 16 characters long, but could go up to say 35 characters long From the description of data types in HELP for VBA, it looks as if there is an overhead of 10 bytes/string for variable length strings. --ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strings
On Sun, 12 Jun 2005 at 07:26:08, Ron Rosenfeld (Ron Rosenfeld
) wrote: From the description of data types in HELP for VBA, it looks as if there is an overhead of 10 bytes/string for variable length strings. Thanks for that - I just looked at help for string and it didn't mention the overhead -- Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
How to find number of pairs of strings from list of strings? | Excel Worksheet Functions | |||
How can I count strings within strings | Excel Worksheet Functions | |||
Finding strings within strings | Excel Programming | |||
Finding strings within strings | Excel Programming |