Hello All,
I am new to database development. I am
working on a pre-existing database application in VFP generates
invoices for various templates and then print them. Once you click on
the issue button, invoices get generated for the specified templates
and then they are automatically printed out. What is happening is that
when you issue the invoices...process gets slow and it takes time for
the invoices to get printed out. I was thinking of creating another
service that only prints the invoices. What should happen is that when
i issue the invoices, they should automatically send to another
application which just print these invoices. So, i can perform another
job in the pre-existing VFP application instead of waiting for the
whole process to complete. It slows down the performance.
What
is the best and most efficient way of doing that? I really need help on
this one since I am very new to programming. The sort of service i
need...it should be like when i start the database application..the
service runs in the background without slowing down the database and
all it does print the jobs that are automatically send to it once the
invoices are issued...
Waiting eagerly for your response..
Thanks in advance
Loading
ShaniPosted May 8, 2008, 9:56 AM
what is really need is asynchronous processing. The way i can do this is by loading the invoices to be printed into a table with a status that indicates they are pending. Then the second service periodcially checks this table to find items that are pending and processes the ones found.
How do i go about doing that...? any article or anything that can help me out..anything...dont know Visual FoxPro..
Mike GoldPosted May 7, 2008, 10:22 PM
are your invoices being created in a separate thread that queues invoices and sends them to the printer? If so, you probably don't need another application, just design the application so the invoices are printed running on a different thread. If you have more than one CPU, .NET will automatically allocate the processing to a different place.
-Mike