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


Reply via email to