Real Time Data collection from Socket and Storing in Excel
Real Time Data collection from Socket and Storing in Excel
Real Time Data collection from Socket and Storing in Excel
Real Time Data collection from Socket and Storing in Excel
Real Time Data collection from Socket and Storing in Excel
Real Time Data collection from Socket and Storing in Excel Real Time Data collection from Socket and Storing in Excel Real Time Data collection from Socket and Storing in Excel Real Time Data collection from Socket and Storing in Excel Real Time Data collection from Socket and Storing in Excel Real Time Data collection from Socket and Storing in Excel Real Time Data collection from Socket and Storing in Excel Real Time Data collection from Socket and Storing in Excel
Real Time Data collection from Socket and Storing in Excel Real Time Data collection from Socket and Storing in Excel
Real Time Data collection from Socket and Storing in Excel
Go Back  Xtreme Visual Basic Talk > > > Real Time Data collection from Socket and Storing in Excel


Reply
 
Thread Tools Display Modes
  #1  
Old 01-06-2012, 12:29 AM
benikvarun benikvarun is offline
Newcomer
 
Join Date: Jan 2012
Posts: 1
Default Real Time Data collection from Socket and Storing in Excel


Dear All,
I m new to this forum. Thanks for welcoming in advance
I m new to VB 2008Express programming. I m into automation development of FMCG products using Micro-controllers. So,VB is pretty new to me. Well , all said..
I get real time data Barcode 2D from TCP/IP connection. My task is to compare the result do some Computation with them and Store the incoming Barcode and results into a Excel sheet in a folder. I m successful with the basic working.
Am currently working at slow speed of 1 barcode(22 char info) per second from the TCP/IP data (barcode scanner). Now, comes the real issue. I need to process atleast 5 barcodes per sec ( <200ms per process). I m partially successful with 3 Barcode per second(300 ms per process).
so, thats like 300ms per processing. I need to achieve less than 200ms for entire processing. I have used threads and timers. but I m unable to achieve.
Seems like storing in Excel takes more than 250ms.
Since i come from micro controllers background 1msec is a lotta time to process for me. I m not sure how much time does it take and trust me i find it difficult to guage the time here.
Please Help me with this. I m stranded with this issue and find no where to go.
Please advice me on the approach that i should be taking. I m attaching the code.
Thanks for viewing this.
Kindly Help me.
Attached Files
File Type: txt code.txt (8.0 KB, 5 views)
Reply With Quote
  #2  
Old 05-18-2012, 10:52 PM
lamy's Avatar
lamy lamy is offline
Junior Contributor
 
Join Date: Jan 2003
Location: under your bed
Posts: 347
Default

there are couple of things that you should consider
- network stream
- computation being done
- rendering information in your app, the more verbose the slower it will be
- saving it to excel

i think for the receiving part it can be handled with multiple threads, as for the slowness of storing to excel try writing to a plain text file (csv) instead
__________________
slow down when you need to hurry, stop when you need to move on,
look back when you need to forget, or you might slip and leave sanity
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Real Time Data collection from Socket and Storing in Excel
Real Time Data collection from Socket and Storing in Excel
Real Time Data collection from Socket and Storing in Excel Real Time Data collection from Socket and Storing in Excel
Real Time Data collection from Socket and Storing in Excel
Real Time Data collection from Socket and Storing in Excel
Real Time Data collection from Socket and Storing in Excel Real Time Data collection from Socket and Storing in Excel Real Time Data collection from Socket and Storing in Excel Real Time Data collection from Socket and Storing in Excel Real Time Data collection from Socket and Storing in Excel Real Time Data collection from Socket and Storing in Excel Real Time Data collection from Socket and Storing in Excel
Real Time Data collection from Socket and Storing in Excel
Real Time Data collection from Socket and Storing in Excel
 
Real Time Data collection from Socket and Storing in Excel
Real Time Data collection from Socket and Storing in Excel
 
-->