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 :)

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 :)

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 :)

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 :)

"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.

--