Now that the out of synch/duplication issues with TSales data have been resolved i find I have a odd and surprising problem using the Desk API and pulling real time TSales data...
Goal...
Using the mutiple handle method: To pull TSales data for 30 stocks (Dow Index) in real time - ONLY trades - NO quotes - and insert the ts data into an SQL server db.
(Filtering out quotes and receiving only trades in the handles cuts out a lot of ts data records)
My HardWare...
P3 / 750mhz with 1Gig Ram - Win2000 os with latest service paks
Result:
With this PC I can successsfully and accurately pull TSales trade only data (30 stocks) with no problem during the slow parts of the day. During the first 1 and half hours of the opening and the last 2 hours of the close i get mutiple repeats of this error:
Automation Error: System Call Failed
where my CPU goes to %100 for a 3 or four minutes and then this error happens. I code my app so that it automatically restarts winsig.exe and starts downloading the TSales for these 30 stocks within seconds so i am back up but i am having about 35 to 45 crash errors like this a day... overall i add up that i am losing 60 minutes of data a day for these 30 stocks - a significant amount... i am not trying to pull 300, or 150 or 75 - just 30 stocks... that's all...
so... i think - well of course i just need more CPU power since i am a little out of date as far as clock speed and mhz goes right...
so using my partners P4 / 2.8 system with
and a fast dsl line and with plenty of ram (512mb)... no Hyperthreading
and we crash (get the Automation Error) MORE !!...
so then i decide ok... lets go to the big mama... i have access to a Windows 2003 server with 2 Xeon 2.8 ghz Processors each having Hyperthreading turned on and a Gig of ram on a fast Biz Dsl line... which gives up 2 physical processors and 2 logical processors (4 total) so i run my app and FIND I CRASH MORE (auto error again - only error)...
crash crash crash ... AND THE CPU USAGE ON THE DUAL XEON SYSTEM NEVER WENT PAST 40% if it ever even got that high - ...
this was at 11:50am pst... so after a number of crashes on the powerful server that happend every two minutes i went back to my P3 / 750 and ran my app for about 20 minutes without a problem although again it crashed a number of times a little later going into the close
so what tha???
Jim Becker17 has some ideas about this but i will let him post if he would like...
Chris James...
Goal...
Using the mutiple handle method: To pull TSales data for 30 stocks (Dow Index) in real time - ONLY trades - NO quotes - and insert the ts data into an SQL server db.
(Filtering out quotes and receiving only trades in the handles cuts out a lot of ts data records)
My HardWare...
P3 / 750mhz with 1Gig Ram - Win2000 os with latest service paks
Result:
With this PC I can successsfully and accurately pull TSales trade only data (30 stocks) with no problem during the slow parts of the day. During the first 1 and half hours of the opening and the last 2 hours of the close i get mutiple repeats of this error:
Automation Error: System Call Failed
where my CPU goes to %100 for a 3 or four minutes and then this error happens. I code my app so that it automatically restarts winsig.exe and starts downloading the TSales for these 30 stocks within seconds so i am back up but i am having about 35 to 45 crash errors like this a day... overall i add up that i am losing 60 minutes of data a day for these 30 stocks - a significant amount... i am not trying to pull 300, or 150 or 75 - just 30 stocks... that's all...
so... i think - well of course i just need more CPU power since i am a little out of date as far as clock speed and mhz goes right...
so using my partners P4 / 2.8 system with
and a fast dsl line and with plenty of ram (512mb)... no Hyperthreading
and we crash (get the Automation Error) MORE !!...
so then i decide ok... lets go to the big mama... i have access to a Windows 2003 server with 2 Xeon 2.8 ghz Processors each having Hyperthreading turned on and a Gig of ram on a fast Biz Dsl line... which gives up 2 physical processors and 2 logical processors (4 total) so i run my app and FIND I CRASH MORE (auto error again - only error)...
crash crash crash ... AND THE CPU USAGE ON THE DUAL XEON SYSTEM NEVER WENT PAST 40% if it ever even got that high - ...
this was at 11:50am pst... so after a number of crashes on the powerful server that happend every two minutes i went back to my P3 / 750 and ran my app for about 20 minutes without a problem although again it crashed a number of times a little later going into the close
so what tha???
Jim Becker17 has some ideas about this but i will let him post if he would like...
Chris James...
Comment