performance windows services
From: freddy parra (freddyparra_at_discussions.microsoft.com)
Date: 03/04/05
- Next message: Alex: "RE: Why no serious MS Application in .NET yet ??"
- Previous message: Jim Robertson: "How do I create an object?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 4 Mar 2005 15:39:03 -0800
Hi
We are using a VB.NET dll to execute a process (load and validate a file).
Sending process from a Windows Application, its load rate is 16000 to 18000
regs/min.
The same process is sended as a thread from a windows service (also
developed in VB.NET) and load
rate decreases a lot. File size is a factor that decreases performance. Rate
falls to 50% - 20% of inicial medition.
Windows services use normal threads (no pooled threads). When each thread
finishes work, notifies the
results to the service and this writes the trace.
The dll process is
Load Dataset from disc.
Load File Format from SQL 2000 Database to VB 6.0 object.
Read each line from file, break line and insert segments in dataset table as
the format says.
Validate data in dataset. If there are errors, the load fails generating
notification and end process.
Insert dataset rows in sql server temporary tables.
Validate data completion, refussing registers with data not allowed using
Stored Procedures.
Insert temporary data into final tables (using same sql server).
Notificate results process.
Service and dll .NET use other dlls made in VB 6.0, however this is not done
frequently.
Thanks for your help.
- Next message: Alex: "RE: Why no serious MS Application in .NET yet ??"
- Previous message: Jim Robertson: "How do I create an object?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|