Performance Question

[krill]

Hi guys...hopefully this is a straight forward question for some one.

Previous the applications that I'm updating was a Access 97 program using Access as the front end.

I have now converted this application..its still at present uses the Access 97 database as the back end, butI have re-written the front end in VB6 using ADO and Crystal 8 to deliver reports.

Both version runs from a Access Database from a mapped drive on a Novell network

The quest I have been asked is my app now using less bandwidth over the net work compared to the previous All in Access version.

Any ideas?

 

[chiph]

It's hard to say, as you don't know what network traffic Crystal is doing. But you can find out if you're running Windows 2000. Go into your network properties and check the "Show icon in taskbar when connected" option. You should now get the double-computer icon near your clock. Now stop your email, web browser, anti-virus, Instant Messenger, Windows Explorer and anything else that might cause network traffic.

Write down the current number of packets sent and received (hover your mouse over the icon to see this). Start your old app and run through a few screens. Write down the new packet values. Subtract the two, and if you're on ethernet, multiple the result by 1450 (which is the usual ethernet packet size), giving you the approximate number of bytes sent and received.

Now do the same thing again with your new version, making sure to navigate your app through the exact same screens. Do the math, and you'll have the number of bytes sent by your new version.

Hope this helps.
Chip H.

 

[krill]

Thanks!

Only problem is that I don't have access to the network with a Win 2000 client. Do you know of any utilities Shareware) that can provide the same information?

Ta

Krill