Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4777 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Hi, we are testing a situation where the external SQL data source is hosted externally and we must connect to it over the internet. The connection is set up and works ok. sorts and finds are quick for 100's of records, but for 10000+ records finds and sorts are unusable. There is no filmaker server in the mix.. im just connecting with filemaker pro 10

I am wondering if a way to speed i up may be to

A) have filemaker server running at the end point and then a filemaker pro client accessing it frmo server..

or

:B Have filemaker server running on the server at the external data center and access filmaker server over the web that way

are either of these 2 options going to speed things up???

Posted

ok so i tried installing FM server at the client end... made things worse... I wonder if installing it at the server end and connecting to it that way will be quicker?

Posted

well.. finally got FM server installed actually on the Server and its all running fine over he internet.. quite impressed!

Thanks all for your help and feedback in this thread... really couldnt have done it with out you!

God bless. X

  • 2 weeks later...
Posted

i like that humour...

I need to do something similar. Can I just check I understand correctly: you don't have FM Server running locally at all. Instead it runs in the same data center that hosts the external SQL data source. right?

  • 2 years later...
  • Newbies
Posted

Hi there,

Do you mean the FM Server 10 and the MSSQL are on the same server?

My fm database has an external data source which connects to MSSQL (on another server, different from my FM server 10). When i published to IWP, it is really really slow!!!

Please advise.

This topic is 4777 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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