提高了将数据写入MYSQL数据库的性能 [英] increased the performance for writing the data into the MYSQL database

问题描述

在我的应用程序中，在将数据表插入到结束后，将使用一个线程将数组值插入到数据表中，并使用一个线程将该数据表插入到MYSQL数据库中.在第一个线程中，数据表行的长度是可变的.
考虑例如第一个数据表包含12行
第二个包含1000行
第三列包含700行
在更新数据库时，我将使用dataadapter.update(datatable)
这些所有线程在第一次快速释放然后第三次释放然后第二次释放时都在此行停止.但是我想以数字方式&释放它们.还提高了更新数据库的性能.此过程将缓慢进行.
任何已知的解决方案均可提高将数据写入
的性能 然后，MYSQL数据库告诉我.

In my application i will be used the one thread for inserting the the array value to the datatable after ending the inserting into the datatable start one thread for insert this datatable into the the MYSQL database. In the first thread the datatable rows are variable in length.
consider e.g 1st datatable contains 12 rows
2nd contains 1000 rows
3rd contains 700 rows
in the updating the database i will be used the dataadapter.update(datatable)
these all threads stop at this lines when first release fast then third release then second release.but i want release these in the number wise & also increased the performance for updating the database.this process will be worked slowly.
any one known the solution for increased the performance for writing the data into the
MYSQL database then tell me.
yanks in advance.

推荐答案

我没有完全得到您想要的....但是如果问题与线程和性能有关，则应使用BackGroundWorkder Component(control )，也可以使用一个类AutoResetEvent按相关顺序执行线程...

链接1 [ Link2 [

I did not get what you want exactly.... but if matter is related to thread and performance then you should use BackGroundWorkder Component(control) or you can use one class AutoResetEvent to execute your thread in related sequence...

Link1[^]
Link2[^]

这篇关于提高了将数据写入MYSQL数据库的性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！