Hi to all Today I inserted as a Test 100 Records in my DB. I repeat therefor 100 times the same "Insert into...". The Job starts and I wait, and wait, and wait. I say, Programm hangs or died, because I do a Mistake in Code. But it isn't.
The Job needs really so much time. Trace-Message shows me, what he just do. I look and search over a few hours in the Docu and older Mails and search with Keywords like "Faster", "Performance", "Disable Journal" and so on. Some Results was successful. After I perform the "PRAGMA synchronous=OFF" it works much faster. If I see it right, now I cannot Rollback, because Journal is disabled. Is it so? And is it recommendable? Or is it a "Never to this..."? ;-) Is there perhaps any other way to make it faster (...with Customizing some parameters)? In the moment I'm just a little bit confused... which adjustment has which effect? Greetings, Anne -- Echte DSL-Flatrate dauerhaft für 0,- Euro*! "Feel free" mit GMX DSL! http://www.gmx.net/de/go/dsl
