Daniel CW Tan


Hello All.

I am currently having a VFP9 application shared in a network that also include VOIP telephony & email servers. Up to 30 users in all. The VFP9 "exe" file is only 3Mb and the database files totalling 5Mb.

It seems that the VFP9 application runs awfully slow at times while the others runs fine.

Could the VFP9 application the main reason why the slowness . How to improve on this

Thanks in advance. Hope to get help.

Regards

Daniel




Re: VFP9 application in same network with email server & VOIPs

dni


How you open database file Are you using buffering Do you have SET MULTILOCKS ON and SET OPTIMIZE ON Are tables indexed





Re: VFP9 application in same network with email server & VOIPs

Daniel CW Tan

Hi dni. Thanks for the reply.

I am using optimistic table buffering, multilocks off and optimize is on. Yes, tables are indexed.

I am not sure if the network is using low bandwidth or if it's one of the factors as well

Actually it works fine just before the VOIP was implemented.

Regards

Daniel






Re: VFP9 application in same network with email server & VOIPs

Dan Freeman

You have actually answered your own question.

It was OK before VOIP, and it's slow after.

VOIP will use huge amounts of bandwidth. Either buy more bandwidth, or remove VOIP and your network applications (such as the VFP applications) will be fast again.




Re: VFP9 application in same network with email server & VOIPs

Daniel CW Tan

Wish it was that easy, Dan. VOIP is the management decision and like the "in" thing. Long story short, the network guys are saying that the VFP application is inefficient. But I need to find some way to compare the impact of VOIP (if it is true that it's the cause of it). I would really appreciate it if anyone knows of any tools that can I can use to test whether which application is at fault. You know, the culprit application. So that I can decide if the VFP application needs to be redesigned or even change the application into another platform, ".Net" even.

Thanks all.

Daniel.





Re: VFP9 application in same network with email server & VOIPs

Dan Freeman

Reality manifests itself in many ways.

I'm reminded of a client who complained our software was slow. Nobody else had that complaint and this client refused to believe it could possibly be their network. No problem there!

On investigation, we discovered that the NIC in their server was throttled at 10 Mbit. Once we removed the throttle and let it operate at 100 Mbit the application started behaving properly and quickly. Their comment to us was "Wow, everything else is faster too, so what's wrong with your software "

Your case is black and white. Before VOIP, it was fast. After, it's slow. It isn't rocket science to see cause and effect.

You can, of course, use packet sniffers to determine what's using up the bandwidth but those are tools of professional hardware jockeys. Those guys are expensive. A less expensive test would be turning off VOIP for a day.




Re: VFP9 application in same network with email server & VOIPs

Daniel CW Tan

I understand. Maybe that's precisely what had to be done, using network diagnostic tools to measure the performance and pinpoint the cause however expensive as long as its worthwhile and can eradicate this problem.

Shutting down the VOIP for a day is out of the question because I did suggested it and was slammed left & right. They claimed that it will be costly as it affects all departments (whatever that really means!). Basically they just are just being stubborn and arrogant.

Thanks for your input.





Re: VFP9 application in same network with email server & VOIPs

dni

Can you give a phone IP and a workstation IP Normally "VOIP" use different networks...I f so you may try to use an other computer as server for "vfp" ( who is not voip server neither e-mail server....)




Re: VFP9 application in same network with email server & VOIPs

Daniel CW Tan

According to the network guys, the VOIP, email server and the server for the VFP application are separate independant servers and each has different IP address. They are housed in the same computer room and linked to workstations. The cabling runs across two buidlings backbone connected via fibre optic cables between switches.

I am also unable to get information on the network map to have a fuller picture of the wirings & connections. They (network guys) also have this "need-to-know" attitude like as if the whole darn thing is classified thus my predicament here. I try to find out if anyone had a VFP application running side by side with email servers & VOIP and have similar experience and if there is a way to work around this problem.

Daniel.





Re: VFP9 application in same network with email server & VOIPs

dni

As I said normally there are different networks and different server, so vfp speed is not affected by VOIP. (I have basically same configuration as you).

You may try first to put:

SET MULTILOCKS ON






Re: VFP9 application in same network with email server & VOIPs

Daniel CW Tan

Ok, I will try "Set Multilocks On".

Thanks, dni.