how to load 2gb data daily

[SunilChauhan]

hello all i have csv of 2gb .

how to load 2gb data on daily basis.

[rbecher]

What's the problem with it? Can you describe your issue..

[SunilChauhan]

i have one csv file of 2gb i want to convert into qvd.

but i extract into qlikview . system hangs.

what can i do?

[rbecher]

The file size shouldn't be a problem...

Which OS version? Which QV version?

Are you short on memory?

Are more than one table involved (synthetic keys etc.)?

How is the format of the CSV (delimiter, quoting etc.)?

How many records?

[boryspower]

Is it anything You could load incrementally? Like transactions etc?

[SunilChauhan]

os is window microsoft windows xp version 5.1.2600

we have both qlikview 9 and 10.

i have 2gb of Ram

Only one table

csv is in  delimiter format

records:approx 9000000per month ( 300000 lacs per day)

[rbecher]

Is the qvw file empty before loading the CSV file? Why you want to store/convert data into a QVD file?

Can you post your script?

[SunilChauhan]

Thanks for reply

yes qlikview file is empty.

i want to compress data using qvd.

or if if you have some other way then please explain.

actually i am not able to fetch Csv file into qlikview

after selecting Csv  file system hangs.

[#9]

in 32bit enviroment the virtual address space of processes and applications is limited to 2 GB.

In this case, sometimes I used the /3GB switch.

view :

http://dwf.blogs.com/beyond_the_paper/2009/04/enabling-3gb-switch-on-windows-vista.html

http://msdn.microsoft.com/en-us/windows/hardware/gg487508.aspx

[SunilChauhan]

Thanks for Reply

How to achieve /3GB  switch?

is it already available.