[OSM-dev] Mass imports (TIGER and AND)

[Tom Hughes]

In message <0DA7FAF2-EB1D-4D0C-B0EF-B1B13036A99C at asklater.com>
        Steve Coast <steve at asklater.com> wrote:

> On 29 Aug 2007, at 00:15, Tom Hughes wrote:
>
>> Well the transaction's a bit pointless, but that's the sort of
>> thing - you need to make sure you call the right validation between
>> creating the node and saving it as we don't currently have everything
>> in the right place - too much is done manually by the controller
>> rather
>> than being built into the model.
>
> Why is the transaction pointless? Isn't it _good_ that the entire
> call would succeed or fail?

That would certainly be a good aim. Unfortunately we're using MySQL
and half our tables are MyISAM so it just gives false hope to use
them with our database as only the InnoDB tables will be rolled back
correctly on transaction failure.

Tom

-- 
Tom Hughes (tom at compton.nu)
http://www.compton.nu/