Memory error

[carlos13]

i am getting following error.

OUT OF VIRTUAL AND/OR LOGICAL MEMORY, allocating 2 mb

I'm working with these files, I could help find a solution.

thanks

[srchagas]

U using a S.o Whith 32 or 64 bits?

probably  the load in B.D you giving is too large and  they can't  allocate in  memory correctly, advise you partition your load, for example, making 30 in 30 days ... something like that.

[carlos13]

Charging is not anything big is 599K, what happens is that I do a table scan to create a temporary, as shown in the Test file and arrange the columns.

[carlos13]

Any help!

Thanks

[srchagas]

U try read That qvd u attach?

because in my server don't have that problem, ur System is 32 or 64 bits?

[carlos13]

Works in 64-bit, maybe it's something in the script that are performing poorly or can be done in a more optimal.

[srchagas]

U using Load * ? or something like that?

[#8]

try with some less column if it will works then try to load partition table(i.e, load table  by part)

[carlos13]

No, in the archive "test" your can see the load

[carlos13]

As I can carry the load of the partition table?