Hello Greg,
Sunday, March 18, 2001, 9:29:45 PM, you wrote:
>> The only problem I see here - i don't know how innobase/bdb will
>> handle tables without primary key... i think perfomance should not be
>> so good as with myisam. Still there is a possibility to load all data
>> to myisam and then run alter table which adds all indexes required and
>> then converts the table to format required on the same pass.
>>
GC> Agreed, but it would be nice if this was automatic with mysqldump ?!
GC> Although a gut feeling would be that create myisam table, insert, create
GC> indexes, convert will be slower.
Well. Index creation and conversion can be done in one pass if I'm not
mistaken.
--
Best regards,
Peter mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
