Hi,
I can confirm, that Aleksey's application is working fine.
The index action:
100524 23:51:38 24 Connect t...@localhost on testdb
24 Query DESCRIBE `automobili_news`
24 Prepare [1] SELECT `automobili_news`.* FROM
`automobili_news`
24 Execute [1] SELECT `automobili_news`.* FROM
`automobili_news`
24 Quit
The update action:
100524 23:52:00 25 Connect t...@localhost on testdb
25 Prepare [1] UPDATE `automobili_news` SET `status`
= ? WHERE (id IN (1, 2, ...))
25 Execute [1] UPDATE `automobili_news` SET `status`
= 'INACTIVE' WHERE (id IN (1, 2, ...))
25 Quit
Just one connection, like everyone said in this discussion ;-)
But Саша is cycling through a result set, manipulating and saving row per row.
Anyway, the fact that only one connection would be used stays the same. :)
--
Regards,
Thomas