BusinessObjects Board

what is the temp space required

dataservices performance
#1

Hi what is the temp space required for 10 million records. my jobs are failing while doing a table comparison with 5 million records in tables

Thanks in advance.

dammalapatisree (BOB member since 2014-07-03)

#2

There is no way we could know that. It depends on many factors that you haven’t provided. Check with your DBA.

eganjp :us: (BOB member since 2007-09-12)

#3

Table comparisons generally use the memory of the server. Is your job failing due to lack of memory? Try looking at the task manager on the job server to see what is happening in terms of memory usage or cpu.

Also maybe you should get the dba’s to perform a database trace on the process to see the database memory usage.

bods_style (BOB member since 2014-04-02)

#4

Hi Sree,

Are you comparing all the columns?

I think no need to compare all the columns of the target and source tables.

What is the table comparison method you have used? Row-by-Row/Cache/Sorted?

Are you using any date filter to restrict the rows?

Arjun (BOB member since 2008-07-28)