This Forum use TRANSACTION ?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=16907
Printed Date: 15 April 2026 at 11:00pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: This Forum use TRANSACTION ?
Posted By: RAVALON
Subject: This Forum use TRANSACTION ?
Date 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...
|
Replies:
Posted By: michael
Date 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. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: RAVALON
Date 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....
|
Posted By: michael
Date Posted: 14 October 2005 at 9:12am
|
they don't need to support it unless you change the code to use t's ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: JJLatWebWiz
Date 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. ------------- 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. |
Posted By: RAVALON
Date Posted: 15 October 2005 at 6:27am
thanks 
|