From: Philippe Cand <[EMAIL PROTECTED]>
> - Is there a way to script MySQL to execute a list of commands then execute > the load query? Yep, Perl makes this whole list of tasks simple. Or possible, depending on your stance. If you don't write any Perl, then I'd say to use a batch script and write things to files for temporary storage durring the query/load process. But in the end, you'll almost certainly still need to do some text processing of some kind in between the databases. So I'd suggest getting some proceedural language involved. > - Is it possible to query a corporate db from within MySQL using existing > native Oracle SQL queries? No. > - Is it possible to have these queries ran automatically every nights? Yep. It looks like you need to support NT, so I'd say to look into the built in scheduler. You'll have to create a batch file (*.bat) and have the scheduler run that. > - I will have to load daily about 10M rows accross about 20 tables . Is > going to fit in a 3 hours time frame? Good question, but very dependant on your hardware and current load. I'd say to try some tests. > - Which would be the best MySQL version for this application... The probably isn't a lot of difference for your application. > I could install MySQL on the D drive of a win2k/1GB Ram server, I have 25GB > free on the D drive. is it going to be OK? Probably, accept for the fact that you are using a MicroSoft OS instead of some flavor of UNIX. I'm afraid that I just don't know how much of your performance will get eaten up by NT itself. --- Rodney Broom Programmer: Desert.Net Spam filter: sql database --------------------------------------------------------------------- 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
