binary load

[ssriramin19]

I am using the binary load  to load the datafor my report. The original  application was of the size 626 Mb and after using Binay load the size got increased to 669 Mb . Why is that after using Binary load the size of the  application got increased  ?

There is no objects and charts in the front end . But even then the size of the report got increased .Why is it so?

Can anyone please tell what is the reason

Thanks

Sriram

[anbu1984]

In original application, may be compression(User preferences-->Save-->Compression) might to be set to High.

[ssriramin19]

No compression is not set to high . It is none. Nothing is specified in compression

[#4]

hi sriram,

ther will be a default selction of compression is high

[ssriramin19]

But in the original file it is set to none in the new file which I created using binary load the compression is set to high.But even when the compression is set to high the size of the new file should get reduced but why the size of the new application have got increased.

[Anonymous]

Well that's a weird issue!

First thing i would say is in the new document where you are doing binary load, do have any script written after the binary load to transform the data further for any need. If so, the answer lies there.

Or just to be sure of, you can check the row counts of all the tables before and after and see if you notice anything weird. You can just go to table structure view and hover your mouse pointer over the tables to view the row count of the tables.

Hope this helps.

Aadil

[ssriramin19]

But then value of each field and record count for all the tables should remain same in both the reports. One with binary load and the original report.

Am I right?

[Anonymous]

Exactly. But is it same or different.

and do you have any script in the binary loaded document.?

These things should rule out the basic issues.

Please check.

-

Aadil

[ssriramin19]

There were only default statements after binary load statement. The usual set statements are being used after binary load statement .But anyway I did tried by commenting all the set statements and now  the file size of both the reports are same.

Thanks Aadil for the suggesting to check the record counts.