如何加快多线程套接字程序以保存SQL Server中的接收数据 [英] How to speed up multi thread socket program for save received data in SQL server

问题描述

我写了一个多线程套接字程序，它监听10个端口并接收数据然后将数据保存到我的数据库。虽然我使用任务但执行程序非常慢。这个程序在使用数据库时很慢。

如何用并行类和任务加速我的程序？



什么我试过了：



i试图加快我在数据库中保存数据的任务

解决方案

< blockquote>关系数据库不是为快速摄取数据而设计的，尝试查看关键/值，文档等非关系数据存储。



RaptorDB - 文档存储 [ ^ ]

没有获得更多信息我认为使用并行编程或任务不是工作的最佳工具。阅读本文



收​​听多个端口。 [ ^ ]

我使用任务和并行编程，但我不知道如何使用任务和并行将数据保存（插入）到我的数据库中

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

解决方案

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[^]

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.[^]

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

这篇关于如何加快多线程套接字程序以保存SQL Server中的接收数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！