Ninth Prince has asked for the wisdom of the Perl Monks concerning the following question:

I have a program that reads in web pages, does regular expression matches and puts the results into a MS ACCESS database. Initially, the program worked fine -- with a run resulting in about 180,000 observations being added to the (previously empty) database. I added more variables to collect (from the expression matching) -- there are around 10 - 15 variables, total -- and now the program results in "Error: 1101." Reading the output from PerlExpress, this looks like some sort of memory/disk space problem, but I have over 10 gig left (of a total of 50 gig on my laptop).

Can anyone help me understand what is going on? Thanks.

Replies are listed 'Best First'.
Re: Out of memory/disk space?
by apl (Monsignor) on Jun 10, 2008 at 14:01 UTC
    You originally added 180,000 records; how long were they? When you expanded the record, did you update those earlier records as well as adding new ones? How long are the new records? How many indices are you using in the table?

    Can you show us the code causing the problem?

    Revised: this seems to indicate that the error is due to there not being enough space for tempdb, and suggests a few ways to add space.

[reply]
Re: Out of memory/disk space?
by linuxer (Curate) on Jun 10, 2008 at 13:58 UTC

    maybe it's a file size limitation of your filesystem?

    what size is your db file now? what is the filesystem the file is stored in?

[reply]

Back to Seekers of Perl Wisdom