I have 768 MB of RAM and a Pentium 4 CPU running at 2.40 GHz.
Should I ask for more RAM?
-- Craig
Chris wrote:
It's a ram issue. Either your putting too much into an array/hash and not clearing it out or you do not have enough ram. I use perl for large SQL jobs, but I run it on a box with 4gb of memory.
Regards,
Chris
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Cardimon Sent: Wednesday, March 17, 2004 9:51 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Problems inserting data into SQL Server using Perl
I'm inserting lots of data into SQL Server. One record at a time, but as many as 40-50,000 records at one sitting. I keep running into the following error:
***
0000932858-03-000025.nc qualifies but had a SQL Error while inserting data: [911] [1] [0] "[Microsoft][ODBC Driver Manager] Memory allocation failure" File size: 23060.37109375 KB, 22.5198936462402 MB, 0.0219920836389065 GB
***
The Mmmory allocation failure doesn't happen every time. In fact, it occurs only a few times. I am working on a large enough number of records, however, with a few records being 22 megabytes and above, that the failures are noticeable.
Does anyone have suggestions?
-- Sincerely,
Craig Cardimon, Programmer AUS Inc. (Knowledge Express Data Systems; 1-800-529-5337, ext. 24)
_______________________________________________ ActivePerl mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
