On Wed, 11 Jun 2008 07:13:10 -0400, Jerry Stuckle
<jstucklex@attglobal.net> wrote:


>> ENGINE=MyISAM DEFAULT CHARSET=utf8;
>>
>> so that proves that I have MyISAM type of table? When I created this
>> table using php I didn't specify MyISAM or InnoDB.
>>
>> If yes, can I do anything to reduce the size of the table?
>>
>> Cheers,
>>
>> Geoff
>>
>
>Yep, this is MyISAM, which is the default most shared hosting companies
>use. It's easy to optimize your table; connect to the database and
>issue "OPTIMIZE TABLE tablename". It can be done from a MySQL command
>line, but it can also be done from any programming language where you
>can issue other MySQL calls.

Thanks Jerry - wil give that a go.

Cheers,

Geoff