Jump to content
Sign in to follow this  
mshar

fmxdbc_listener possibly slowing down server

Recommended Posts

We have using been Filemaker for years and started doing some more develpment in ASP.NET using ODBC drivers provided with Filemaker. Our Filemaker Server is version 11 and ODBC driver is 11.3.81.0. We are experiencing extreme slowness form the server and any kind of operation like browsing thru records using the client is also slow.

When we restart the service fmxdbc_listener, it helps for a while and then intermittently starts to slow down again.

I have a few questions:

1. Is this expected when fmxdbc_listener is loaded with more requests form applications?

2. Is there a better way to query FMP databases (like Stored Procedures in SQL Server) instead of dynamically creating SQL queries in code?

3. Where should I be looking at to troubleshoot?

Thanks,

Max

Share this post


Link to post
Share on other sites

Please update your Profile to reflect your current versions of FileMaker, OS and Platform. Use this quick link My Profile

TIA

Lee

Share this post


Link to post
Share on other sites

www.fmDotNet.org may be an alternative. It uses the XML API that is included with regular FMS and FMS Advanced. XML traffic is more verbose than XML traffic but it usually is more robust/stable

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  

  • Similar Content

    • By Aabhi
      I'm trying to open OST file in C#. I'm using below code but still facing error. I got stuck while creating an application.

      filter = "[ReceivedTime] >= '" + dtpStartDate.Value.ToString("dd/MM/yyyy 12:00 AM") + "' and [ReceivedTime] <= '" + dtpEndDate.Value.ToString("dd/MM/yyyy 11:59 PM") + "'";

      Outlook.Application outlookApp = GetApplicationObject(); Outlook.Folder root = outlookApp.Session.DefaultStore.GetRootFolder() as Outlook.Folder;

      EnumerateFolders(root); Outlook.MAPIFolder inboxFolder = outlookApp.Session.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderInbox);

      inboxTable = CreateTable();
       
      After the search on Web, I have found few sources where the solution of this problem is provided. But I don't know which solution will fix my problem. Please refer below sources.
      https://community.rackspace.com/general/f/general-discussion-forum/8881/how-to-open-ost-file-using-c-code
      https://www.nopcommerce.com/boards/t/56083/how-to-open-ost-file-using-c-net.aspx
      https://www.stellarinfo.com/convert-ost-to-pst.php
      http://forums.codeguru.com/showthread.php?562219-How-Do-I-Open-OST-file-using-C

      Please help.
  • Who Viewed the Topic

    1 member has viewed this topic:
    Carson 
×

Important Information

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