From: wangxu Sent: Thu 12/04/2007 08:38 > ----- Original Message ----- > From: "Martijn Tonies" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Thursday, April 12, 2007 3:17 PM > Subject: Re: when rebuilding keys? > > > >> yes. > > > >> >> before load data. > >> > > >> > You want to rebuild the indices after loading data, > >> > correct? > > > > Then what exactly is the question? > > > > > > Please write your answer BELOW, not above. > > > > Martijn Tonies > > Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & > > MS SQL Server > > Upscene Productions > > http://www.upscene.com > > My thoughts: > > http://blog.upscene.com/martijn/ > > Database development questions? Check the forum! > > http://www.databasedevelopmentforum.com > > > > > > sorry ,my english is poor. > > There is a observable event. > My table's engine is myisam. > Rows above 1000000 in my table. > I did "alter table ......disable keys" before loading data. > I did "alter table ......enable keys" after loading data. > The operation of enable keys is so fast! > > I am not sure than if the keys have been rebuild.I think the course of > rebuilding should need very long time.
Try inserting a duplicate value into one of unique columns and see if you get an error. If you do they are working. mark -- MARK ADDISON WEB DEVELOPER 200 GRAY'S INN ROAD LONDON WC1X 8XZ UNITED KINGDOM T +44 (0)20 7430 4678 F E [EMAIL PROTECTED] WWW.ITN.CO.UK Please Note: Any views or opinions are solely those of the author and do not necessarily represent those of Independent Television News Limited unless specifically stated. This email and any files attached are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please notify [EMAIL PROTECTED] Please note that to ensure regulatory compliance and for the protection of our clients and business, we may monitor and read messages sent to and from our systems. Thank You.