| # |
Sep 13th 2009, 14:06 |
markstory |
$db->commit() etc. |
| # |
Sep 13th 2009, 14:06 |
markstory |
$db->begin() |
| # |
Sep 13th 2009, 14:06 |
ionas82 |
yes markstory I got that |
| # |
Sep 13th 2009, 14:06 |
markstory |
you are using the wrong table types. |
| # |
Sep 13th 2009, 14:06 |
ionas82 |
but how should I call transactions |
| # |
Sep 13th 2009, 14:06 |
markstory |
and everything to do with your database |
| # |
Sep 13th 2009, 14:06 |
ionas82 |
thats fine |
| # |
Sep 13th 2009, 14:06 |
markstory |
it has nothing to do with cake. |
| # |
Sep 13th 2009, 14:06 |
ionas82 |
on innodb? |
| # |
Sep 13th 2009, 14:06 |
markstory |
use innodb |
| # |
Sep 13th 2009, 14:05 |
ionas82 |
using saveAll ? atomic: If true (default), will attempt to save all records in a single transaction. |
| # |
Sep 13th 2009, 14:05 |
markstory |
not use myisam |
| # |
Sep 13th 2009, 14:05 |
ionas82 |
markstory, what's the recommended way to enable transactions? |
| # |
Sep 13th 2009, 14:05 |
ionas82 |
but I get that MyISAM doesn't do it simply |
| # |
Sep 13th 2009, 14:05 |
ionas82 |
markstory, I have no clue (as you see) |
| # |
Sep 13th 2009, 14:05 |
markstory |
because that is unpossible |
| # |
Sep 13th 2009, 14:05 |
savant1 |
book search sucks :) |
| # |
Sep 13th 2009, 14:05 |
foofoo |
http://api.cakephp.org/search/rollback |
| # |
Sep 13th 2009, 14:05 |
markstory |
ionas: and you expect transactions to work on myisam? |
| # |
Sep 13th 2009, 14:04 |
ionas82 |
ah now |
| # |
Sep 13th 2009, 14:04 |
ionas82 |
book search not working :E |
| # |
Sep 13th 2009, 14:04 |
ionas82 |
hm |
| # |
Sep 13th 2009, 14:04 |
ionas82 |
~transaction |
| # |
Sep 13th 2009, 14:04 |
ionas82 |
foofoo, I will consider that but first dig into mark's direction |
| # |
Sep 13th 2009, 14:03 |
foofoo |
myisam doesn't support transactions, so if that's an abstraction to transactional storage engine stuff then you need to switch to innodb |
| # |
Sep 13th 2009, 14:03 |
ionas82 |
yeah its a dbo method |
| # |
Sep 13th 2009, 14:03 |
ionas82 |
okay |
| # |
Sep 13th 2009, 14:03 |
ionas82 |
hm |
| # |
Sep 13th 2009, 14:03 |
ionas82 |
myisam |
| # |
Sep 13th 2009, 14:02 |
markstory |
because last I checked it was a dbo method. |
| # |
Sep 13th 2009, 14:02 |
markstory |
when did models get a rollback method? |
| # |
Sep 13th 2009, 14:02 |
foofoo |
ionas82: what storage engine are you using on your tables? |
| # |
Sep 13th 2009, 13:59 |
ionas82 |
I am on MySQL 5 |
| # |
Sep 13th 2009, 13:57 |
ionas82 |
http://book.cakephp.org/search/rollback working for you? |
| # |
Sep 13th 2009, 13:57 |
ionas82 |
hm |
| # |
Sep 13th 2009, 13:56 |
ionas82 |
http://monmonja.com/blog/2008/07/transaction-on-cakephp-12/ |
| # |
Sep 13th 2009, 13:56 |
ionas82 |
like this? |
| # |
Sep 13th 2009, 13:56 |
ionas82 |
http://bin.cakephp.org/view/1679118033 |
| # |
Sep 13th 2009, 13:56 |
ionas82 |
any idea why $this->rollback() is not working? |
| # |
Sep 13th 2009, 13:53 |
cewi |
thats true thx |
| # |
Sep 13th 2009, 13:53 |
burzum |
depending on your needs i would benchmark each way and choose the fastest, if time and processing power doesnt matter just make it work :) |