|
|
Posted by frizzle on 10/16/79 11:39
Jerry Stuckle wrote:
> 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
> ==================
Ok, thanks a lot for all the effort. No more further questions ...
for now ;)
Again, thanks a lot for taking so much time!
Frizzle.
Navigation:
[Reply to this message]
|