No, I can't recall what it is in mysql, but it's similar to Oracle SQL loader. It allows to insert data based on different specifications, delimiters, etc...
Maybe someone more familiar with MySQL can comment. As far as loading and extracting XML data, there are also a few modules that might help in getting this accomplished. XML::DBMS, DBIx-XML_RDB and a few others, can't recall their name at this time. All utilize DBI but allow to easily insert, retrieve data based on schemas, specifications, etc..., and are customizable. Ilya -----Original Message----- From: Mark Riehl To: ''[EMAIL PROTECTED]' ' Sent: 10/17/01 12:29 PM Subject: RE: mod_perl and DBI Ilya/Doug - Thanks for the info. Sorry for not being too clear. Our application will have an upload of a large (~5 MB) XML file, it will need to be parsed, and then stored in the database. The database will then be manipulated by another process, data will be pulled out, and an output XML file will be generated. We're using the database as a common are to share the data. One last question. When you mentioned native load facility, do you mean bypassing DBI and using the database directly (e.g., running INSERT commands from the MySQL command line rather than through DBI)? Thanks, Mark -- Mark Riehl Agile Communications, Inc. Email: [EMAIL PROTECTED] > -----Original Message----- > From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 17, 2001 1:56 PM > To: 'Wilson, Doug '; ''Mark Riehl' '; ''[EMAIL PROTECTED]' ' > Subject: RE: mod_perl and DBI > > > Right, Doug. I was not clear on the question myself. Later > after rereading > I realized the batch load part of it. You are correct that the native > loading facilities are much faster than DBI. > > Though my answer was directed towards the "This isn't online > system... and > the mod_perl vs. standard Perl interpreter" part of the question:-) > > Ilya > > -----Original Message----- > From: Wilson, Doug > To: 'Mark Riehl'; '[EMAIL PROTECTED]' > Sent: 10/17/01 11:24 AM > Subject: RE: mod_perl and DBI > > > Let me clarify that I think Ilya and I are answering > different questions, and not positive which question was > being asked :) > > For a prolonged process like a large SQL load, mod_perl won't help > much; but when the scripts are shorter (and other factors like > perl load/compile and database connection & statement handle > preparation time are more significant), it can be beneficial. > > > From: Wilson, Doug > > > All - We're putting together a Web-based application using > > > Perl CGI, Apache, > > > and DBI to connect to a MySQL database (all running on one > > > machine under > > > Win2k). Off the command line, I can load a source file > populate the > > > database with ~25000 records in less than 5 seconds, however, > > > using CGI and > > > the same DBI code takes ~30 seconds. This isn't an online > > > system and won't > > > receive many hits - only one or two users at a time. > > > > Native load facilities are usually quicker than the equivalent > > DBI code. mod_perl won't help much, if at all. Best solution > > might be to have your CGI download the file and use the native > > load facility. >
