[EMAIL PROTECTED] wrote:
> I'm working with large numbers of files that can vary in size up to 4
> GB and more. Every time I try tackling them straight on I run out of
> virtual memory. The files are sequentially numbered somewhat like SS
> numbers -- they contain hyphens. The file numbers are unique as far
> as I can tell.
>
> Is there a loop I can use that will process the first 10,000 files,
> then exit; then the next 10,000 files, then exit; and so on until all
> files have been processed? The exiting is so I can run a SQL Server
> job to insert the processed files into SQL Server.
>
When you say 'insert the processed filesinto SQL Server'. Are they just
the file names or is there related data that is being collected? If only file
names, then there has to be something else going in your program. If you are
collecting data, then you can loop on a count of 10000 and then use either
backticks ( so you can review output) or system ( success or failure) to run
your SQL processing.
Wags ;)
> -- Craig
>
>
> ---
> avast! Antivirus: Outbound message clean.
> Virus Database (VPS): 0539-0, 09/26/2005
> Tested on: 9/26/2005 11:41:28 AM
> avast! - copyright (c) 1988-2004 ALWIL Software.
> http://www.avast.com
>
>
>
> _______________________________________________
> ActivePerl mailing list
> [email protected]
> To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
*******************************************************
This message contains information that is confidential
and proprietary to FedEx Freight or its affiliates.
It is intended only for the recipient named and for
the express purpose(s) described therein.
Any other use is prohibited.
*******************************************************
_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
