what to expect...? (mysql on free webhosts)

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
newmember
Forum Contributor
Posts: 252
Joined: Fri Apr 02, 2004 12:36 pm

what to expect...? (mysql on free webhosts)

Post by newmember »

Hi

I'm currently experimenting with mysql and php...
i see that there are different kinds of database engines to choose for table.
There are innodb,myisam,isam and others engines.

What type of engine should i expect to find on free webhost?

N.B.
maybe i shouldn't care about it at all :?
bobsta63
Forum Commoner
Posts: 28
Joined: Thu Apr 21, 2005 7:03 pm
Location: Ipswich, UK

Post by bobsta63 »

myisam i would have thought, Not sure though
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

Firstly if you're just starting out it wont affect you much.

Secondly... you should be able to specify the table type when you set the database up. Use phpMyAdmin... it will probably be installed already by your host :D
Roja
Tutorials Group
Posts: 2692
Joined: Sun Jan 04, 2004 10:30 pm

Re: what to expect...? (mysql on free webhosts)

Post by Roja »

newmember wrote: What type of engine should i expect to find on free webhost?
Generally, myisam is a given, and in some of the decent free hosts, you can find innodb.

I've almost never seen a free host offer something other than those two by default.
newmember wrote: maybe i shouldn't care about it at all :?
That depends on what you want to do. If you want transactions, you'll want to have innodb. Transactions are really rather powerful and nice, and can help avoid the need for DB locking.

But if all you want is update and select, you don't need to worry much. :)
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

User avatar
newmember
Forum Contributor
Posts: 252
Joined: Fri Apr 02, 2004 12:36 pm

Post by newmember »

ok i get it
thanks guys
Post Reply