|
|
Posted by Jerry Stuckle on 11/17/46 11:39
frizzle wrote:
> Jerry Stuckle wrote:
>
>>frizzle wrote:
>>
>>>I actually use PHPmyAdmin, but don't know where to set it to INNODB, or
>>>my host disabled that, (i can choose form 3 other ones though ...)
>>>
>>>Frizzle.
>>>
>>
>>After you select the table, go to the Operations tab. One of the
>>entries is "Table type". Change this to INNODB.
>>--
>>==================
>>Remove the "x" from my email address
>>Jerry Stuckle
>>JDS Computer Training Corp.
>>jstucklex@attglobal.net
>>==================
>
>
> The only options i get there are:
> - MyISAM (current)
> - Heap
> - ISAM
> - Merge
>
> So i guess it's not possible (yet). But i have things up and running
> correct now, or do you think it's that important to go use foreign
> keys?
>
> Frizle.
>
OK, you're hosting company may have an older copy of MySQL, may not have
installed INNODB support or whatever.
INNODB will allow you to ensure the integrity of your foreign keys. For
instance, if you delete a row in your main table, it can automatically
delete the matching row(s) in your full text table (other options are
available also). Without it, you can't guarantee the integrity of the
database.
So it all depends on how important it is to you. You'll probably be ok
- this isn't like a bank, for instance, where you don't want to delete a
person's record while they still have open accounts. If you have some
extra rows in your full text table it might slow the server down a
couple of milliseconds is all.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|