Unix Technical Forum

InnoDB table vs myIsam table

This is a discussion on InnoDB table vs myIsam table within the MySQL forums, part of the Database Server Software category; --> hi I can use InnoDB table every or I better using MyIsam table when i'm not need specially (InnoDB) ...


Go Back   Unix Technical Forum > Database Server Software > MySQL

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 11:21 AM
gabryfan
 
Posts: n/a
Default InnoDB table vs myIsam table

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-28-2008, 11:22 AM
=?iso-8859-1?B?Sm/jbyBNb3JhaXM=?=
 
Posts: n/a
Default Re: InnoDB table vs myIsam table

> 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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-28-2008, 11:22 AM
Peter H. Coffin
 
Posts: n/a
Default Re: InnoDB table vs myIsam table

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:10 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com