Hello, We are considering moving to MySQL as our production database. We use of for testing and small tasks now, but to move to production we need to efficiently solve a few problems.
The first, and probably the most critical, is that we need to be able to run an update that once a week updates between 5 million and 100 million rows of data. This update doesn't update all of the rows, nor all of the columns in the fact table that it is modifying. In databases like Oracle, the most efficient way to do this is to create a separate table and use SQL to do the update with a subquery. In databases like Teradata and Redbrick, there are tools that will do the update directly from a file if it is formatted correctly. What is the most efficient way to do it in MySQL? I'm willing to write as complex Perl, C, or whatever is necessary to make this fast. Thanks, Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
