I need to commit a mutirecord form. I query based on a request id and retrieve info;', then scan barcodes and commit the data. On committing, update a few fields in addition to the scanned barcode. I do it for one record using CGI-Perl. Is there a better way to commit ten or more records at a time?

Otherwise you'll have to write your own multiplexing print function -- or your own tee program -- or use Tom Christiansen's, at http://www.perl.com/CPAN/authors/id/TOMC/scripts/tct.gz, which is written in Perl and offers much greater functionality than the stock version.</pre><HR></BLOCKQUOTE>

If this doesn't address your questions, could you please provide more information about what you're trying to do regarding record commitment?

Thanks, but I'm not sure what would be appropriate and how to go about it.

Should I commit after each record or commit after say 10 records? for the following problem: I query the database for a given request_id,which say retrieves 500 request_members. For each of the 500 records a barcode entry is made. These entries have to be updated in the database.

Currently: I write the results of a single queried record to a file and then update one record at a time. When I update for a single record, I use a file to store the results of my query and one to store the update or errors. I'm using CGI.pm

Unless I'm missing something key, it looks like a matter of 6 in 1, half a dozen in the other... not much different. The only thing I can see is that it may be more efficient to waiting to do several records at once (10 at a time) is that relevant modules would have already been loaded into the program, and that your records are in memory.

This looks like a personal preference decision -- Probably the best way to see what's more efficient (that is, what may be the better way to do it) is to try it both ways and do some benchmarking.