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

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

Recommended Posts

Posted

I have just discovered that a particular database we're hosting on our FMSA11 box (Windows Server 2003) has developed an appalling response time for XML-based web calls since migrating to this server. It worked fine when it was on our old server (FMSA8 on OS X Server).

We're hosting over 70 other databases, many of them also publishing data to the web (I'm using FX.php), and this is the only file exhibiting this slowness. And by slowness, I mean over 15 seconds to return data from a table that has a single record and only 6 fields.

No errors are reported anywhere, it's just really slow. I managed to isolate the problem to this file by rebuilding this one particular simple table into another file, and it performs fine from the new file. That's only one tiny part of the database though, and I use the rest too, so I can't just rebuild it all.

I have tried cloning it, optimising it, renaming it, etc, but nothing makes any difference, and I can't figure out what's going on! It works fine when being opened from FileMaker 9 or 10 clients.

Help!

Kev

Posted

No - but have you turned your attention to that the file might be corrupt?

http://fmdiff.com/fm/filecorruption.html?session=ti5eri8j2894mq4ak9pmu4hpnjs5agjq

--sd

Posted

I have indeed. It works without any problem at all from within the FileMaker client app, but I optimised it anyway (using Save As...smaller copy). I even used the 'Recover' option, but neither action made any difference.

On both of our FMSA11 boxes, 2 different versions of the file exhibit the same issue. So I fired up our old FMSA8 box, which still had an earlier version of the file on it, and it showed no problems with web-based XML data transfer. Frustrating!

Anyway, in the end, the guy who built the original file has built a cut-down version from scratch, just to interact with the web, and it's working fine.

Kev

This topic is 5232 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.