This Forum use TRANSACTION ?

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
RAVALON Members Profile Find Members Posts Groupie Joined: 31 December 2003 Location: Italy Status: Offline Points: 132	Post Options Post Reply Quote RAVALON Report Post Thanks(0) Quote Reply Topic: This Forum use TRANSACTION ? Posted: 13 October 2005 at 4:57pm
	Hello.... porting this forum to mysql db, i ask me if this forum use in some special function transaction system or not.... i ask to sell which type of table use....for transaction or not...

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply Posted: 14 October 2005 at 12:01am
	every stored procedure being executed is a transaction so not 100% sure what you are asking... generally though, there are not "special" transactions here, just good 'ol stored procedures and sql statements.
	Blog \| MPG Tracker

RAVALON Members Profile Find Members Posts Groupie Joined: 31 December 2003 Location: Italy Status: Offline Points: 132	Post Options Post Reply Quote RAVALON Report Post Thanks(0) Quote Reply Posted: 14 October 2005 at 8:38am
	what i would ask is... i've finished conversion from this forum Access to Mysql (for personal use only) In Mysql you could specify if tables will support or not transaction... In access version i don't see transaction code...so to be sure, i ask to you....

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply Posted: 14 October 2005 at 9:12am
	they don't need to support it unless you change the code to use t's
	Blog \| MPG Tracker

JJLatWebWiz Members Profile Find Members Posts Groupie Joined: 02 March 2005 Location: United States Status: Offline Points: 136	Post Options Post Reply Quote JJLatWebWiz Report Post Thanks(0) Quote Reply Posted: 14 October 2005 at 12:08pm
	Are you talking about Transact SQL transactions as in BEGIN, COMMIT, and ROLLBACK a transaction?� Microsoft Access does not use transactions, so the Access version of WWF could not have any such code.� The stored procedures used by the MS SQL version of WWF also do not use transactions. I don't remember where I heard this or if it's been fixed in MySQL Version 5, but in order to use transactions in MySQL your tables must use the InnoDB engine instead of the default myISAM engine and the myISAM engine is much faster than the the InnoDB.� So if you don't�NEED transaction support, stay with myISAM for maximum performance. Edited by JJLatWebWiz - 14 October 2005 at 5:01pm
	p.s. I'm not affiliated with Web Wiz Guide in any way. I'm just an average Web Wiz user repaying my debt for the use of their fine forum by trying to help other Web Wiz Guide users.

RAVALON Members Profile Find Members Posts Groupie Joined: 31 December 2003 Location: Italy Status: Offline Points: 132	Post Options Post Reply Quote RAVALON Report Post Thanks(0) Quote Reply Posted: 15 October 2005 at 6:27am
	thanks

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.