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

[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

[PlatinumBay]

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

<01*******@gmail.comwrote in message
news:11*********************@o11g2000prd.googlegro ups.com...

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

[AlexS]

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

Alex
<01*******@gmail.comwrote in message
news:11*********************@o11g2000prd.googlegro ups.com...

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

[01423481d]

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