How to speed up multi thread socket program for save received data in SQL server

Question

1.00/5 (1 vote)

See more:

I write a multi thread socket program that listen to 10 ports and receive data then save data to my database. although i use tasks but execution of my program very slow. this program slow where it work with database.
how i can speed up my program with parallel class and task?

What I have tried:

i have try speed up my task for saving data in database

Posted 23-May-16 22:00pm

Member 7956511

Updated 24-May-16 9:29am

Add a Solution

Comments

Richard MacCutchan 24-May-16 4:05am

Without more information it is anyone's guess.

3 solutions

Solution 2

Without gaining much more information I think that using Parallel programming or tasks are not the best tool for the job. Have a read of this

Listen on multiple ports.[^]

Posted 24-May-16 0:04am

Simon_Whale

Updated 24-May-16 0:05am

v2

Solution 3

I use tasks and parallel programming but I do not know how to save(insert) data into my database with tasks and parallel

Posted 24-May-16 9:29am

Member 7956511

Comments

Matt T Heffron 24-May-16 16:50pm

Don't post a comment on someone else's solution as a new Solution.
Use the "Have a Question or Comment?" button below the Solution.
Or in the case of replying to a comment, use the "Reply" button next to the comment.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Accepted Answer · 2016-05-23T23:41:00

Solution 1

Relational databases were not designed for rapid ingest of data, try looking at non-relational data stores like Key/Value, Document etc.

RaptorDB - The Document Store[^]

Posted 23-May-16 23:41pm

Mehdi Gholam

Comments

Member 7956511 24-May-16 15:32pm

i do not familiar with non-relational data stores and work with these

Matt T Heffron 24-May-16 16:54pm

This is making a huge assumption that the problem is overwhelming the database.
It could be a poor implementation of multi-threading.
Like Richard MacCutchan stated, there really isn't enough information to know where the bottleneck is.