Hi all,

I am using sql compact 3.5 sp2 on windows ce 6.0 and I noticed that every aprox. 13 seconds something happens which increases insert time significantly (larger the db bigger the increase).

I have a table whit cca 70 columns and I insert one line per second. When the db is empty the insert takes few ms (8) and up to 50ms every 13 sec.

But when the db is getting bigger 500 000  inserts this time increases to aprox. 30 ms and goes over 500ms every 13s.

Has anyone noticed this. Is there something I can do about this?

Thanks in advance,

best regards,

Greg

It is statistics being rebuilt.

You can try table direct.

Or try my sqlcebulkcopy lib (Wraps table direct for you)

it is also possible to delete and recreate statistics... but unsure if that will do you any good

Hi Erik,

Thanks for your answer.

I am inserting one row per second. I thought sqlcebulkcopy is meant for large number of rows to be inserted at once?

Thanks,

Grega

try to use table direct... (like SqlCeBulkCopy does)