Shall I use threading

Question

Hi,

I am building a windows service which would use different data pumps to load the data in database. Now theses data pumps have different sources and while inserting data they refer to same database tables, stored procedures multiple times.

Is it good idea to have these pumps in different threads?

 

 

Answer 1

you can use multithreading to dump the data. if you use threading it will improve performance of your application.

but you have to take care about Data Integrity and duplcaiton of data.

 

regards

nil

Answer 2

You are asking a developer question in a forum dedicated to .NET Framework installation and setup.

There are several forums where you can get good suggestions from expert devs.

The forum dedicated to data apps is here:

http://social.msdn.microsoft.com/Forums/en-US/vstsdb/threads

Other dev forums are categorized by language.

For VB: http://social.msdn.microsoft.com/Forums/en-US/category/visualbasic

For C#: http://social.msdn.microsoft.com/Forums/en-US/category/visualcsharp

For C++: http://social.msdn.microsoft.com/Forums/en-US/category/visualc