multithreading - c# am I handling multiple threads properly -

multithreading - c# am I handling multiple threads properly -

I have a Winform application that creates 5 threads to connect and get to a database on a slow connection (90 seconds for some queries). Each thread has its own example of a class to run SQL queries. When the queryed data is retrieved, the main thread is notified by an event removed from the class that runs the query. After receiving the event, various components of the main thread are updated such as display item or data holding data for later use.

Everything works great ... but I am not happy. I think it should be done in a different way, but I'm not sure how to

Below I am currently setting each thread:

  string ConnectionString = @ "data source = mySrv; initial catalog = myTbl; connect timeout = 30; uid = Pwd = mipvand "; // thread # 1 SQL_Requests ReasonRequests; Thread Rezinhaith; ReasonRequests = new SQL_Requests (); ReasonRequests.ProcessFinished + = New SQL_Requests.ProcessFinished (ReasonRequests_Completed); Reason_Thread = New thread (ReasonRequests.ExecuteQuery); ReasonRequests.DBQueryString = "Select from ReasonTable *, Where Stirling = Welcoming" ReasonAx DBC connection = connection string; // Thread # 2 events of SQLRUV; Thread event tag; EventRequests = new SQL_Requests (); EventRequests. ProcessedFilter = New SQL_Requests.ProcessFinished (EventRequests_Completed); Event_Thread = New thread (EventRequests.ExecuteQuery); EventRequests.DBQueryString = "Choose from EventTable * where somefield = somevalue" EventRequests.DBConnection = ConnectionString; 
 
  
 Itemprop = "text">  Instead of spinning your sources, you should take a look as an asynchronous method to execute the questions 
  Did you mention that your connection is slow, is it a low bandwidth connection or a high latency connection? If for many years the data is being returned slowly due to inadequate bandwidth firing, then things will get slower, if there is a delay in many questions at one time, accountability can improve. 
  If you are performing a group of related questions, then you should consider grouping them in one command or grouping it on the server using an stored procedure. Es. You can get additional results set by using the NextResult method on SqlDataReader.








03:22

















Get link





Facebook





X





Pinterest





Email





Other Apps




Comments





Post a Comment







Popular Posts




linux - C++: undefined reference to `sd_notify' -



    i'm new c++. problem have process creates lot of processes, want identify(get pid) of 1 of children. looping through children take lot of resources(don't ask why). i'm trying pid of process (somehow) identifying if uses sd_notify  , pid(i don't if possible). i'm using ubuntu 14.04 , created little test program:   #include <systemd/sd-daemon.h> #include <stdio.h>  int main() {   int a;   = sd_notify(0, "ready=1");   printf("%d -> \n", a);   fflush(stdout); }   but gives me error saying undefined reference 'sd_notify' .   p.s  found sd_notify  systemd systems. equivalent of in upstart systems? or how can make sure process i'm searching doen't use function? or possible log messages send processes using sd_notify ?          try installing libsystemd-daemon-devel  , compile using   g++ -o sig sig.cpp -lsystemd-daemon       











server - Httpd(apache) is not starting on fedora 23 -



    i tried install nginx , didn't work. after tried install , configure apache(httpd) server on fedora23 dist. server doesn't want start namely doesn't work , returns errors , when try start it: sudo systemctl start httpd  job httpd.service failed because control process exited error code. see "systemctl status httpd.service" , "journalctl -xe" details.   , after saw logs in journalctl -xe . shows this:       jun 28 11:26:49 cyber audit[15981]: cred_refr pid=15981 uid=0 auid=1000 ses=1 subj=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 msg='op=pam:s jun 28 11:26:49 cyber sudo[15981]: pam_systemd(sudo:session): cannot create session: running in session jun 28 11:26:49 cyber kernel: audit: type=1105 audit(1467095209.363:842): pid=15981 uid=0 auid=1000 ses=1 subj=unconfined_u:unconfined_r:unconfined_t: jun 28 11:26:49 cyber sudo[15981]: pam_unix(sudo:session): session opened user root (uid=0) jun 28 11:26:49 cyber audit[15981]: user_start pid=1...






ios - Swift: Realm accessed from incorrect thread -



    i pass previous view controller. want show data save in other view controller.       override func prepareforsegue(segue: uistoryboardsegue, sender: anyobject?) {     if (segue.identifier == "beacons") {           let nav = segue.destinationviewcontroller as! uinavigationcontroller         let svc = nav.topviewcontroller as! beaconcharacteristicviewcontroller         svc.selectedlist = sender as! beacons       }   and         var selectedlist : beacons!   and code error reason.   i don't use primary key or have use it.       func loadproperties(){        let beacons = selectedlist        let priority = dispatch_queue_priority_default        dispatch_async(dispatch_get_global_queue(priority, 0)) {          do{             try uirealm.write({ () -> void in                  beacons.uuid = self.beaconuuid.text!                 print("uuid = \(beacons.uuid)")                  beacons.major = self.beaconmajor.text!                 print("uuid = \(beacons.u...








Powered by Blogger