Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
does Excel have memory limit of data Array?
Hi everyone,
Now I writting a VBA function in Excel, firstly I use ADO to read the data in table into data array in Memory. I found in some case the function is running will, some case the function go to deadlock. I check the situation in case deadlock, I found I read a huge data into data array, then the function run very slow and go to dead lock. anyone know whether MS has memory restriction of data array? if so, do I need control the data size which need read into array?? thanks in advance :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
does Excel have memory limit of data Array?
Define "huge" - we may all have different ideas of what this means...
Tim. "miao jie" wrote in message ... Hi everyone, Now I writting a VBA function in Excel, firstly I use ADO to read the data in table into data array in Memory. I found in some case the function is running will, some case the function go to deadlock. I check the situation in case deadlock, I found I read a huge data into data array, then the function run very slow and go to dead lock. anyone know whether MS has memory restriction of data array? if so, do I need control the data size which need read into array?? thanks in advance :) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
does Excel have memory limit of data Array?
the records more than 100000
"Tim Williams" wrote: Define "huge" - we may all have different ideas of what this means... Tim. "miao jie" wrote in message ... Hi everyone, Now I writting a VBA function in Excel, firstly I use ADO to read the data in table into data array in Memory. I found in some case the function is running will, some case the function go to deadlock. I check the situation in case deadlock, I found I read a huge data into data array, then the function run very slow and go to dead lock. anyone know whether MS has memory restriction of data array? if so, do I need control the data size which need read into array?? thanks in advance :) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
does Excel have memory limit of data Array?
How many fields, and how are you creating the array?
Tim "miao jie" wrote in message ... the records more than 100000 "Tim Williams" wrote: Define "huge" - we may all have different ideas of what this means... Tim. "miao jie" wrote in message ... Hi everyone, Now I writting a VBA function in Excel, firstly I use ADO to read the data in table into data array in Memory. I found in some case the function is running will, some case the function go to deadlock. I check the situation in case deadlock, I found I read a huge data into data array, then the function run very slow and go to dead lock. anyone know whether MS has memory restriction of data array? if so, do I need control the data size which need read into array?? thanks in advance :) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
does Excel have memory limit of data Array?
"miao jie" wrote ...
I use ADO to read the data in table into data array in Memory. Is it useful to have 100K+ elements in memory? Why not operate on the table using SQL e.g. use a WHERE clause to return only the rows you require. Post more details of what you are using the array for, you may be taking the wrong approach. Jamie. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup Array limit? | Excel Worksheet Functions | |||
Is there an array size limit for MMULT or MINVERSE in excel 2007? | Excel Worksheet Functions | |||
create an array with unique items IN MEMORY | Excel Worksheet Functions | |||
limit to possible array size? | Excel Programming | |||
Excel: Array & Memory | Excel Programming |