Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About FM_Newbie

  • Rank

Profile Information

  • Title
  • Industry

Recent Profile Visitors

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

  1. Hi All, Just saw on the FM website for the FM17, it doesn't support client version 14. If I want to setup a Server - Server Sync solution, Is it possible to do that between FM server 14 and FM server 17?? thanks
  2. @Wim Decorte, Clone file size is approximaltely 8MB, I didnt compact the file size recently but it would reduce around 500 Mb in size. There is just one container field that is using data internally, rest is all stored externally. Problem with Search going slow was due to bad design, i was doing the search on same layout which was used to display different calculated fields from related tables, I have moved the Find Operation to another layout which is based on the the actual table. Results are pretty good. @BruceR, Isn't this the same at the start that we all make silly mistak
  3. Thank You @comment for the demo. I will have a look at the design again to simplify it, i took this from another developer and since it was working so i didnt touch it. Overall the database file size is near 4 GB now (with container data stored externally separately), plus in the respective jobs table there are total 115 fields. Overall this could be making search slower. Thanks again for your help
  4. Hi @webko, Unfortunatley it does change quite often after the record is created.. so can't miss out on any change made ;(
  5. Attached are three files: Script: The script used for search on main layout Field def1: main calculation field used in find field def2: base field on which the calculation field is based on.
  6. hi @comment, Sorry for the confusion on this. I will try to clarify a bit more. The Layout in discussion is 'jobs' table layout and the calculation fields are there for user conveniece to display data from clients table. Also the problem is that user wants to have search on the same layout on those calculation fields. what i meant by getting slower every day was a little sweeping comment out of frustration. The search has gotten slower over the period slowly and it seems quite slower since the start of database.
  7. Thanks for the comments. I will try to explain the scenario here to be clear: There is jobs table and there is clients table. Every Job has more than one clients like where we, pick up, drop off, client who pays etc. Now these clients do change as well during the lifecycle, someone entered wrong client or some other issue. I had to make these client types into jobs table as Calculation fields to update if something changes. The Search is mainly based on 'Search all jobs with same Pick up Address' or likewise. These target search fields are Calculations and hence non-indexed. I h
  8. Hi Guys, I am having trouble with Find Operation getting slower and slower each day. There are some design consideration as per some articles i have read recently which i will be doing as well. I inherited this solution from another developer, Find is based on some Calculation fields which are based further on some other calculation fields (both calculation fields have 'Do not store results' option checked) I know its not the best of designs, i wanted to ask for any possible improvement to Find process as its getting clumsy now. I have indexed relevant fields though, data i
  9. Thanks @bcooney I was able to find a flaw in the design while being stuck with this problem. Your commet was helpful in thinking me towards that direction. Cheers,
  10. thanks @bcooney, i think you are right. I didn't think it through. I will give it a try and search for any such file that may have caused problem while being pushed to server.
  11. Hi Guys, I had been using FM EasySync for few months now, so it had been working fine till now. Without having any change in the table structure, i got the error " The attempt to push data into server has failed ( The mesage recevied rom the server was "852" ) 852 Error is : Cannot write a file to the external storage I believe this is related to container fileds I am using. There has been no change in the Container field options. They are still being stored "Externally" on the server with Open Storage option. Also there hasn't been any change on Server policies as well.
  12. Thanks Josh, I am not currently doing deletion on Mobile side, plan to do it later and will use your version of Sync Check, it certainly takes lesser time. Appreciate your help and guidance in this regard. Cheers
  13. Actually overall Sync is taking alot of time, i guess the bottleneck in my case is the internet speed at both sides, specially at the Host side. EasySync is taking alot of time so i re-deployed it by taking identical copie of the solution and then as both copie update, i am trying to make sure sync is done every 2 hours or less. Usually "Pushing Payload to the Server" takes alot of time, although there are not many changes on mobile side that are to be pushed. Mostly the update is on the Pull side. Occassionally it gives error of "Couldn't receive Payloa d Segements from customer."
  14. Ye, i did. Actually copied the same object from your layout . Also the script "Clear Script Result'' has been added on client as well. just wondering if the variable $$use_psos_during_sync_check should be set to be on "Client" or "Server" it is currently set to "Server" in ping settings.
  • Create New...

Important Information

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