Cache size lookup transformation

Hi,

I have to perform a lookup in a table based on a query like:

"... where ? = [RefTable].fieldID and ? between [RefTable].AnotherFieldValue and [RefTable].AThirdFieldValue"

So, SSIS has put the CacheType to none. As I really need to speed up the job I want to set the CacheType to partial (full isn't an option due to the custom query I use here).

But here it comes: when using partial CacheType, one has to set the cache size manually - and I really don't know what value I should assign to it - is there a guideline on this topic?

I work on a Win2003 server platform with sql server 2005 - 2 processors - 2Gb Ram - enough disc space

Thanks in advance,
Tom

Tom De Cort wrote:

Hi,

I have to perform a lookup in a table based on a query like:

"... where ? = [RefTable].fieldID and ? between [RefTable].AnotherFieldValue and [RefTable].AThirdFieldValue"

So, SSIS has put the CacheType to none. As I really need to speed up the job I want to set the CacheType to partial (full isn't an option due to the custom query I use here).

But here it comes: when using partial CacheType, one has to set the cache size manually - and I really don't know what value I should assign to it - is there a guideline on this topic?

I work on a Win2003 server platform with sql server 2005 - 2 processors - 2Gb Ram - enough disc space

Thanks in advance,
Tom

Tom,

The only person that can answer this question for sure is yourself. Test and measure, test and measure, test and measure...

Differrent scenarios call for different settings so I doubt there are guidelines anywhere.

-Jamie

|||

ok, I will

Thanks Jamie