NYCPHP Meetup

[Daniel Convissor]

On Wed, Feb 28, 2007 at 02:07:34PM -0500, Hans C. Kaspersetz wrote:
> 
> >ALTER TABLE <tablename> DISABLE KEYS;
> >before import and
> >ALTER TABLE <tablename> ENABLE KEYS;
> >after import.
> >
> I am going to look at using DISABLE/ENABLE instead of dropping and adding. 

The manual indicates that's for MyISAM tables.  You said you're using 
InnoDB.

--Dan

-- 
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409