Re: Performance issue concerning about "insert" statement on Pervasive 2000i
- From: "AlexS" <salexru2000NO@xxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 14 Jun 2007 23:00:42 -0400
Take a look at bcp utility, which must exist for your db, or at SqlBulkCopy
class, which are better suitable for bulk inserts
Alex
<01423481d@xxxxxxxxx> wrote in message
news:1181814667.785769.11770@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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
.
- Prev by Date: Problem with running in Debug Mode
- Next by Date: Re: Planning on going with dynamic SQL, but...
- Previous by thread: Re: Performance issue concerning about "insert" statement on Pervasive 2000i
- Next by thread: Trying to better understand dlls....
- Index(es):
Relevant Pages
|
