> -----Original Message----- > From: William H. Bowers [mailto:[EMAIL PROTECTED] > Sent: 22 July 2004 03:55 > To: [EMAIL PROTECTED] > Subject: re: Splitting data across tables > If indexing seems to be the cause of the slowdown, it may be > faster to drop the indexes, add the new data, and then > rebuild the indexes. This is especially helpful with > physical indexing.
I don't think that this would be a good idea for us - we add the data continuiously, and aggregate at least every hour. I'm not confident that we could drop the indexes and then recreate them in less than 60 minutes... Cheers, -- Andrew Hill Developer Awarez Ltd. Kirkman House, 12-14 Whitfield Street, London W1T 2RF T: +44 (0)20 7299 7370 F: +44 (0)20 7299 7374 ---------------------------------------------------------------------- The information in this email is confidential and is intended solely for the addressee. It may be legally privileged. The contents are not to be disclosed to anyone other than the addressee and access to this email by anyone else is unauthorised. Unauthorised recipients are requested to preserve the confidentiality of this email and to advise the sender immediately of any error in transmission. Any disclosure, copying, distribution or action taken or omitted to be taken in reliance upon the contents of this email by unauthorised recipients is prohibited and may be unlawful. ---------------------------------------------------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
