September 29, 2014 at 8:53 am
I have developed over 100 visual basic ADO.net applications (none are web applications) that access local databases (within our office). All of the applications perform well. However, we had one application that was susceptible to a low, wireless connection speed (54mbps). Once we updated to a 5G wireless router, that problem was solved, and it appears that as long as the connection speed is greater than 100mbps, performance is acceptable.
We are evaluating Microsoft Azure to host our databases that will be accessed from the local client/visual basic applications. After installing the databases and associated stored procedures, views, and triggers on the Azure VM and changing the sql server connection string to access the VM, performance is (surprisingly) good. However, the one application mentioned above that is susceptible to a slower connection is once again giving me problems.
When print is called, the susceptible application appends 4 tables in one database with no lost data or problems – fast and slow connections. So far, so good. However, when the information is written to a view in order to populate fields in a report using a slow connection, detail bands in the report are lost. A review of the view shows it is always populated with all the records needed for the report as expected.
The report is only one page and contains one to seven records – each it its own detail band. With a slow connection, records 3,4,5,6,7 or maybe records 4,5,6,7 are printed, and the others never make it to the printed report. I have been told that I am loading the data for the report asynchronously and need to look for an alternative method.
Any guidance is sincerely appreciated.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply