Anne,
Try wrapping your inserts in a transaction. Individual inserts are
quite fast, but transactions are not. Therefor anything that you can do
to reduce the number of transactions will boost the speed. My
preference is to wrap a transaction around every 200 or 300 inserts,
depending on the size of the record.
Clay Dowling
[EMAIL PROTECTED] wrote:
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
--
http://www.lazarusid.com/notes/
Lazarus Notes
Articles and Commentary on Web Development
