Is there any relation between OLEDB reload and RAM size?

[bluecarbon]

Hi All,

When I try to reload data from two different machines to same data source through oledb, the reload time varies a lot.

Below is time difference and I feel it because of the RAM size. Can anyone let me know if it is because of the RAM size the time is getting shorten or is there any other possiblitiy?

30min -> 16GB RAM

5 mins -> 128GB RAM

Thanks,

Rakul.

[rwunderlich]

‌Reload duration can also be affected by number & speed of CPUs, and network connection speed between the QV desktop and the do. Are these factors different on these two machines?

Rob

[bluecarbon]

Hi Arjun,

Yes, I m using the same connections and same credentials.

Thanks,

Rakul.

[bluecarbon]

Yes,

When I try to retrieve the data using Toad there is a difference in time.

Thanks,

Rakul.

[bluecarbon]

Hi Rob,

Thanks for replying. So in my case, the reload speed is getting decreased when there is an increase in CPU. So can I come to a conclusion RAM comes into play only if the data that is getting reloaded exceeds the RAM size. Until then, with more CPUs lesser the reload time.

Thanks,

Rakul.