Page 1 of 1
what to expect...? (mysql on free webhosts)
Posted: Fri Apr 22, 2005 11:23 am
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

Posted: Fri Apr 22, 2005 11:28 am
by bobsta63
myisam i would have thought, Not sure though
Posted: Fri Apr 22, 2005 8:13 pm
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

Re: what to expect...? (mysql on free webhosts)
Posted: Fri Apr 22, 2005 8:58 pm
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.

Posted: Sat Apr 23, 2005 6:08 am
by timvw
Posted: Sun Apr 24, 2005 12:49 pm
by newmember
ok i get it
thanks guys