![]() Make sure to read the first article to fully optimize a FileMaker solution for WAN deployment:Īll the information in this article is available on the internet right now in articles, videos and other mediums so I'll try to specify where I digested the information whenever possible. This is the second article in a series of two articles. Instead, what I have here is a cheat sheet that will assist you in resolving speed issues. There are so many factors that play into how a solution performs that it's nearly impossible to provide the right answer for everyone. Hardware and networking are usually secondary to proper design but it can make a big difference in how your solution performs if you have sub par equipment. You also need to optimize your hardware and network on your FileMaker Server machine. Just because you streamlined your solution during the design phase doesn't mean it's going to react efficiently across a LAN or WAN. FileMaker started out as a DOS application called Nutshell but was shaped into the powerhouse it is today by Claris and FMI. but changed it's name in 1998 when it focused on FileMaker. It was once named Claris when it also sold MacWrite, MacPaint, Claris Emailer, ClarisWorks, etc. or FMI is a wholly owned subsidiary of Apple, Inc. I have seen the deletion of a single record cause the deletion of all records in all tables.įileMaker, Inc. What happens is that since your related records are also your parent records, deleting records can cascade out of control. The Philosophy of FileMaker recommends PCI!Ĭascading Delete Self-join or Same-Table relationships are very useful (two table occurrences from the source table related to each other), but be careful! Don't ever turn on the option to allow deletion of related records! If you do, whenever you delete a parent record you may delete more than you want. Email John Mark Osborne or call John Mark at (909) 393-4664 to find out more about this service. Over programming hurdles via GoToMeeting. Meta-consulting is a service Database Pros offers to help other developers Support this site by clicking on a sponsor below or becoming a patron! ![]() The Philosophy of FileMaker - Server Optimization
0 Comments
Leave a Reply. |