Hi All

Thanks for reading the post first.
I am developing a VB.net interface which reads from a fixed format
text file and insert the records to the pervasive database. However
the performance is not satisfactory (it took about 2hrs to write 70k
records). But one strange thing is that if I query the table using
the SQL data manager during importation, the rate of importing (using
the same interface with nothing change in the database setting)
increases to 10 mins / 70k!

I just wonder why the case happens like that. Could anyone share the
experience on this issue??

Thanks
KC

<01423481d (AT) gmail (DOT) com> schreef in bericht
news:1181966188.368448.256250 (AT) n15g2000prd (DOT) googlegroups.com...
What did you do after your first attempt?
1) Drop the table ("DROP TABLE <table>")
or
2) Just empty is. ("DELETE * from <table>")

i think if you did the second step, that this might indeed cause a quicker
response....