SEO

#1 (**permalink**) 02-28-2008, 10:21 AM

hi

I can use InnoDB table every or I better using MyIsam table when i'm not
need specially (InnoDB) function?

thank's
gabry
webmaster di www.fantogame.it

ciao

io posso usare sempre tabelle InnoDb o è meglio usare tabelle MyIsam
quando non ho bisogno di speciali (InnODB) funzioni?

grazie
gabry
webmaster di www.fantogame.it

#2 (**permalink**) 02-28-2008, 10:22 AM

> I can use InnoDB table every or I better using MyIsam table when i'm not
> need specially (InnoDB) function?

In my opinion, if u don't need InnoDB functions like foreign keys,
transactions, etc.. you should use MyIsam, since not all the hosts
have InnoDB enabled, and MyIsam it's enabled by default.

#3 (**permalink**) 02-28-2008, 10:22 AM

On Sun, 05 Aug 2007 10:56:15 -0000, João Morais wrote:
>> I can use InnoDB table every or I better using MyIsam table when i'm not
>> need specially (InnoDB) function?
>
> In my opinion, if u don't need InnoDB functions like foreign keys,
> transactions, etc.. you should use MyIsam, since not all the hosts
> have InnoDB enabled, and MyIsam it's enabled by default.

It could be argued that foreign keys are necessary parts of any
well-designed relational database and that it is unwise to depend on
application code to enforce those relationships.

--
6. I will not gloat over my enemies' predicament before killing them.
--Peter Anspach's list of things to do as an Evil Overlord

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

InnoDB table vs myIsam table