Memory Leak XML TextReader & SQL Ce Insert?

[info]

I import XML Files using the XML Textreader and SQLCe Inserts on an
PocketPC


I Do nothing more then getting the data from the xml file and adding
these informations to an prepared SQLCeInsert which I then execute.

Normally it takes 23 Seconds for 500 Records. Which is ok

but sometimes the speed decreases very fast and the amount of used
application ram increases (~0,02k in 1,2 Seconds).

Then only an softreset of the PPC helps (Does anyone know this
problem?)

I found an article in which a similiar problem was described. They
supposed to use an DB Flush to solve this problem but I can't find any
c# code.

Does anyone have a code for this and can help me or does someone know
any other problems?

 

[Ilya Tumanov [MS]]

Are you disposing of SQL CE objects like commands?

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

*** Want to find answers instantly? Here's how... ***

1. Go to
http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en
2. Type your question in the text box near "Search this group" button.
3. Hit "Search this group" button.
4. Read answer(s).

 

[Syed N. Yousuf [MS]]

To isolate the problem to XML read or SQL CE insert, try to read from a
text file and insert using the same SQL CE code.

Thank you!
Syed N. Yousuf
Microsoft Developer Support Professional

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[info]

I ran the XMLReader Method for it self nand the memory usage didn't
increase.
I did this with 50.000 Records ten times everytime the same.

So it looks like the save method increases the memory usage
..
When I sometimes close the Connection every 100 Records and reopen it
than the insert speed remains always constant.

After 2 thousend records the used Application ram increased 0,24MB
which seems to be normal as I don't know if garbage collection has
cleaned up all things