> Can you explain this procedure to me a little better or point me to > something I can read? I still have to convince the person who manages the > Oracle box to open up an NFS share.
The point of using NFS to transfer the files from the oracle box to the mysql box is to avoid copying the data twice. If this isn't possible (because the oracle box doesn't already have nfs set up, and the admin doesn't want to make changes...), you can copy the data via any other means. CD-R's, DLT, FTP, scp, wget, .... . NFS would likely be the easiest to use, and cuts out an intermediate step of copying the data to a second location, but it is not necessary. SQL Ryan > Another way we could increase load times > would be to use 4 scripts to load data from 4 tables at once. We have the > bandwith to handle that and the MySQL box seems to be handling request just > fine at 11,000 inserts its still not tapping out both procs or killing the > disk I/O. Though I don't think you'd see much (any?) speed up by doing this, I'll defer to the good judgement of other list members than have more data than me. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
