Hello all
i call insert statement using sqlcommnand object(since
i have to insert binary data)where i am inserting
600k to 2mb's data into the database

i do this spawning 10 threads, i.e. all these threads
insert the 600k to 2mb data continuously reading from file.

what i have noticed is after some 4 to 5 hours of
countinuous
running the system becomes slow and all the threads stop
giving me
time out error(from database insert statement)

Please help me the possible area i can look into

Thanks in advance
Ganesh

Are you moving data from one database to another or simply loading data into
the DB? In either case DTS or BCP would work far better (and faster).

--
____________________________________
Bill Vaughn
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Ganesh" <(E-Mail Removed)> wrote in message
news:0a4701c34b76$b4e2ea60$(E-Mail Removed)...
> Hello all
> i call insert statement using sqlcommnand object(since
> i have to insert binary data)where i am inserting
> 600k to 2mb's data into the database
>
> i do this spawning 10 threads, i.e. all these threads
> insert the 600k to 2mb data continuously reading from file.
>
> what i have noticed is after some 4 to 5 hours of
> countinuous
> running the system becomes slow and all the threads stop
> giving me
> time out error(from database insert statement)
>
> Please help me the possible area i can look into
>
> Thanks in advance
> Ganesh
>