Topic: SG V will be going flatfile, see link... Post edited

[Bonk]

How exactly doe the DB get dirty in SQl?  From what I remembered, AI opbejcts didn't get stuck when I was screweing around with this stuff about a year ago.

I did turns AIs off though . . .

Once during this test, a hex was corrupted by the cartel ownership being set to 2323 instead of 23... that seemed to be where the problems started.

Otherwise it is exactly the same as the flatfile for "dirtying the db"; dead mission AI accumulates from bugged missions caused by bad connections and ALTs. The server AI are created and destroyed regularly (I have it set to create one per turn and destroy up to 10 per turn - which does work - it provides a mimimum of AI, with allowAItotakehexes set to zero of course.)

[Dfly]

could it be a cascaded effect due to a single hex being corrupted?  I know of other issues with other programs I have worked with in the past(not like mySQL) that can cascade once something is corrupted.

[Nemesis]

There is gooing news, we finally got that SQL test we were looking for 

PS:  Can we restart in 2263?   I am a sadist

Sounds good to me but then again I'm a Klingon.