Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About daveinc

  • Rank
  1. Thanks Wim. I will dig around and see if I can identify anything else that is different.
  2. Hi Wim, Thanks for the Zabbix recommendation. I am using that to monitor all of our well-running servers now(although I never need to look at it because they all run very well!). Is there anyone who would know what is indicated when the situation I describe above with the FMTEMPFM files is occurring? I am desperately trying to figure this out with no luck so far and I consider you to be the authority(or at least knowing who the authority would be!) on all things FM. Thanks in advance for any suggestions, Dave
  3. Hi Wim, thanks for responding. I already know what design issues are problematic in this solution. I'm not looking for tips on redesign of the solution, I'm looking for the reason a slower, older, hardware setup performs MUCH better than a newer, faster, hardware setup with the exact same solution, load, hardware settings(# of CPUs, GB of RAM are identical. For Disk Space, the poor performing system has more free space, SSD drives, and Windows on C:(150GB free) Data files on E:(180GB free). The good performing system has far less free disk space, FastSCSI drives, and both Windows and the
  4. Hi, I have a performance conundrum that I have not been able to figure out for the past month and a half or so and am looking here for some guidance. We have a 9-year old FM system that we run our entire Production operation on. We have approximately 150 users in 9 locations across the US and Canada for this solution. We have a Windows Server 2012 VM with 14 CPU Cores, 60GB RAM, and an SSD Array SAN that we run our Production Server on. We have separate Drives configured for the Operating System and Data. All users not in the facility housing the server use Remote Desktop to ac
  5. Value Lists come from the Production Server? Value Lists can be a critical part of development. Or is it only value lists that users can edit(which I never use anywhere, ever)? Just wanting to be clear with this.
  6. Yes. That does not help. I'm even committing the parent record just for good measure.
  7. Wim, I understand the transactional model, and in fact I am using it in this script repeatedly, but again that is not the question I am seeking an answer to. Because of the nature of our parts list, I have to create the initial Base Estimate Line Item records in their native table. The issue is NOT that my transactional edits after all of the records for the multilevel estimate are created are failing at any level. The script in question creates the initial Base Estimate Line Items and all of the initial Tiered Estimate line items based on the user's selection of a Part made up of many materi
  8. Hi Wim, These triggers are all within the estimate and the estimate can only be edited by the Owner. The Estimate MUST update all of the iterations if there is a change to any one of tens of fields that affect price in the Base Estimate. Otherwise our estimators would be spending their entire day creating new estimates for minor changes to the original and piling up hundreds of old worthless records. But that is not the issue anyway. The issue is that a record created in another table isn't seen via any available function through a direct relationship unless a pause is put into the scrip
  9. Hi guys, me again. I've solved this issue myself already but found it aggravating enough that I thought I would post it here and see if anyone else had any similar issues. I have a complicated script that builds an Estimate after the entry of some base information. It is quite fast for the work that it does and has been in use for a couple of years without any problems. The script builds a multi-tiered Estimate for printed materials based on discounting for different quantity levels. The user builds an Estimate from materials and work centers plus markup for the base Quantity then the
  10. Just as a follow up, the FM issues have solved themselves with no direct intervention on my part. I guess it simply needs a week or two to get comfortable? My console still won't allow me to add Scheduled Scripts, but that's a minor issue compared to what was happening before.
  11. Thanks for your advice Josh. I knew the layout changed as to how it was constructed, but I didn't think it would be quite so dramatically slow. I just visited Richard Carlton's site and didn't find a video on converting an 11 layout to a new theme. Do you know where I can find this? Youtube maybe?
  12. The server is a Cove XFM setup that uses a RAID array of Solid State Drives. Top of the line in every facet. It is the exact same machine we had FM11 server on reformatted and setup with FMS13. Windows Server 2008 R2. I don't think it's a server issue, because the server stats are fine all the time. We also bought a number of new client machines to meet the requirements. It's almost like the client can't redraw the screen at an acceptable rate or is hogging resources for something. It happens at different times to different clients on both Macs and PCs, but again far too often to ignore. Regar
  13. Thanks for the quick replies guys. We tested extensively using a similar(but not exact) setup on a sandbox network. Of course we couldn't hire a team of 150 testers from all nine of our locations to simulate a real load. We had 5 testers and even then, we are not performing work at the rates our expert users would. Scripts and finds are not the issue now. Typing in completely unformatted fields is. All files were checked for index problems and compacted before conversion. They were not slow in any fashion during testing, in fact everything seemed faster, but that might have been because we on
  14. Hi guys, We recently upgraded our servers and clients to Filemaker Server13/Pro 12/13 and FM is practically unusable at times(far too often) where simply typing a character in a field takes 10 seconds. It is literally unusable in this state, especially since our users are accustomed to 11 which had it's own issues with slow scripts and finds, but never anything like this that makes it impossible to even work and causes entry errors all over the place while FM catches up with simple data entry. This is a huge database solution used by 150 users in 9 locations and recreating it from scratch wo
  15. Hi, I'm trying to import records via ODBC from FM12 Server to FM11. I can successfully import using the query builder with a WHERE clause but this needs to be a repetitive automated process for a user. I would like to use the Calculated SQL text option and have no problem if I just use a SELECT statement with no WHERE clause to bring in records. As soon as I add the WHERE clause, FQL errors out. The text from the Query Builder is exactly identical to the text from the Calculated SQL text but the Query Builder works and the Calculated SQL Text does not. I have tried every trick I could find on
  • Create New...

Important Information

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