From: Martijn Tonies
Date: October 3 2009 12:21pm
Subject: Transations? (was: Re: login issue..pls help)
List-Archive: http://lists.mysql.com/mysql/218939
Message-Id: <006a01ca4424$0f0074c0$1401a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

Hi,

(better change the message subject if you change, well, the subject)

> user will create more number of tickets per day. so INSERT, UPDATE, SELECT
> will use  highly.
>
> in document says' Myisam will not support transaction but it has self 
> backup
> and restoration method. but in InnoDB good for transaction but no self
> managed backup and restoration..
>
> now how can i choose my engine. ?
>
> my usage is only storage and retrieve data.. so which one is normally
> preferred by all developers

Quite simple really: do you need to store data in one table that depends
on other data in other tables?

If the answer is YES, then use transactions. Without transactions, you
cannot guarantee the data consistency.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com