Performance issue concerning about "insert" statement on Pervasive 2000i

  • Thread starter Thread starter 01423481d
  • Start date Start date
0

01423481d

Hi All

I am facing a very strange "problem" on the captioned issue, I hope I
can explain it clearly.

Actually I am developing an interface (using VB.net) which read
records from a file and then import them to the database. The
performance of the interface was about 20000 records/0.5 hrs. However,
if I query the table using "SELECT COUNT(*) FROM TABLE" from the SQL
Data Manager of Pervasive Control Center during the importation
process, the program will speed up its speed to 30000 records/4mins.
Very strange right? I wonder if someone has some experience on this
issue...

Many Thanks
KC
 
KC,

You would be better off posting this in a database newsgroup. It doesn't
sound like you have a VB.NET question.

However, you may want to look at what triggers and indexes you may have on
the table you are inserting into.

Hope this helps,


Steve
 
Take a look at bcp utility, which must exist for your db, or at SqlBulkCopy
class, which are better suitable for bulk inserts

Alex
 
Thanks for your reply

However for some reasons we cannot deploy .net 2.0 on the client's PC,
and I cannot find any source regarding to bcp utility for pervasive
2000i...
I will try re-posting the question on the database forum, but I
believe it sounds like a VB problem more than a database problem..


HTH
 
Back
Top