Printing invoices from VFP database.

Question

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

Dipal Choksi · Answer

Hi It seems to be a good solution to split out the printing operation which is taking longer.. In general you can use .net Remoting or WCF. Depending on how you architect the solution you may be able to get your implementation by just spinning a new thread or invoking the external application directly. Hope this helps... Good Luck!