Jump to content

Oliver Reid

Members
  • Content Count

    8
  • Joined

  • Last visited

Community Reputation

1 Neutral

About Oliver Reid

  • Rank
    member

FileMaker Experience

  • Skill Level
    Expert
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    10.12.x

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. FM natively handles multiuser updates to the same data very smoothy - if User A updates data User B is looking at, User B's view of it refreshes automatically. This will not happen with data stored in SQL. If that is accepted then you can in fact use FM as front end to a SQL database. SQL database are powerful and ideal for applications with thousands of transactions per minute - just don't use FM for that kind of situation. For a write infrequently/read very frequently application FMP+SQL can work very well. SQL can do some things many times faster than FM , and using SQL views, Triggers and virtual fields will let you see results much more quickly (dramatically so in some cases) than using native FM, especially over a WAN
  2. I will be installing FM Books online (server) and owner if there are demo files anywhere that have examples of a good number of typical transactions and queries - the demo file available on Productive's site is quite limited in scope. TIA Oliver Reid
  3. Spoke with 360works this morning. This is a known issue with High Sierra They will release a fix in a day two -- but that will require moving to the latest version of the plug in
  4. I am seeing EXCACTLY the same same issue with V2 of plug in. Ir worked fine until I Upgraded to High Sierra. The connect step fails Emailasterror returns (after a 30 second wait)" Could not connect to SMTP host: email-smtp.us-east-1.amazonaws.com, port: 465 Note the FM send mail step works fine with the same credentials, but the port is 587, but fails (after about 30 secs) If I set it 465 Fm error 1506 adding reply tracking add reply tracking
  5. I have table with list of addresses. I need simple way to show, visually how they are clustered geographically - ideally one map location "Dot" for each address. Any suggestions - would like to display result on demand in a web viewer
  6. I am closing a down server I have been running housed at Telx in Northern NJ. 96GB, x 6-core Westmere processors 3.4ghz (24 virtual processors) 2TB of storage. Locked cage; ISO 27001-compliant Very low latency to Greater NY and CT If you have a client that needs that kind of resource the cost is reasonable ~$500 per month. Comes with tech support that is excellent. Let me know and I can put you in touch with the Vendor: they will probably dismantle it midweek next week if no-one wants to keep it running. Note I have no financial interest in this situation. oreid@firstgm.com
  7. Make sure the Host Name set in the admin panel is the same as the fully qualified domain used for the SSL That fixed the issue in my case
  8. Actually, the point here I believe, is that FMP is not the best tool for executing high volumes of transactions form many users to a SQL database. However when same workgroup needs to work with large volumes of data, and updates are infrequent I have found " FM as nothing but a front-end to an ESS SQL database." to be a very effective approach, for several reasons -- Searches can be very much faster -- Complex calculations and /or aggregations across many tables, can be very fast using views set up in SQL. You create views that provide "Virtual Flat Tables" of aggregate values. Dramatically fast vs native FM - especially over a WAN. -- Publishing SQL to the web is very scalable using PHP or other tools, and subcontractors to do this are easy to find. So in a write "a few times an hour" read "millions of times", scenario ESS is in fact brilliant. You do have to learn (by experience, unfortunately) the behavior of "Flush Cached External Data" - I have found that to be certain that you are looking at the most current data this has to be done in the "context" of each table that could have been updated - not just in the layout you are looking at. A bit cumbersome. Tools expressly designed for SQL front-ending deal with things like this, and also avoiding "collisions" where multiple users are trying to write to the same record, much better.
×
×
  • Create New...

Important Information

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