Jump to content
Sign in to follow this  

ODBC MySQL Fast internet, slow private network.

Recommended Posts


I have a problem, If you could help me...

We use the Filemaker with a Mysql database (odbc ActualTechnologies, Mac osx 10.5).

All works ok when we connect via Internet. The problem is this:

When we connect via wifi (private network), the UPDATE and DELETE actions are slow (5-10 seconds per create, modify or delete a record). All the other actions (search, navigate) works ok , really fast.

Could you help me?


Share this post

Link to post
Share on other sites

When you say you use wifi (private network) I am assuming you are connecting to a WAP (wireless access point) that is setup to use DHCP and uses a private address pool of 10.x or 172.x or 192.x.

If this is a typical setup for a WAP, it is also probably configured to use NAT (network address translation) in order to create a firewall; which means many clients with private ip addresses share a single ip address to talk to the internet.

I am also going to assume that the server you are trying to reach is not directly connected to your WAP which means it is probably on the other side of the firewall.

If you connect a client machine directly to your WAP instead of using a wireless connection (assuming your WAP has some free ethernet ports on the back, do you still have the same problem? If so, then your problem may be with using NAT on your WAP.

You could try checking what ports are used for your sql server, and forwarding those port numbers to a specific ip address on your WAP, but that limits thing so that only one machine will function correctly.

I have only tested with MS SQL server 2005 on a fixed ip scheme so I don't have the proper things in place on my end to to test out your scenerio, so this is just my best guess...

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.