Hello, with good indeces 100 000 rows is basically nothing. Give it a try.
Peter Nick Meyer wrote: > What is the best way to UPDATE a row only if values are different? We > have a mainframe extract that literally has 100,000 rows and am worried > about the performance of just running INSERTs each night. > > Is there a simple comparison command or would you have to nest a SELECT > statement? Thank you, > > Nick > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
