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 im****tation, the rate of im****ting (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