Hi Again,
You have to optimize a large database (2 Million records).
since I have a huge amount of 'static' records (2 million and more) which will not change any more, and on the other hand at about 2.ooo (growing) records which are updated regulary, I wonder if its useful having those static records in a seperate table...
The SELECT-queries go into a MERGE table which unites the 'dynamic' and 'static' record-table.
Will this speed up my Update-Queries, because the index in the dynamic-table will be built up much faster?
thanks for your help.
Regards, Andy
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
