Edits VERY slow to save again with errors in perfo...

Phil_Waite · 08-15-2022 10:36 AM

Hi,

Edits are VERY slow to save to the googlesheet - sometimes takign hours.

Below is a screenshot the report from gthe performance profile that has an error.

Not sure what is causing it

Phil_Waite

I have a very large main table with about 30 columns and 28K rows but I have a blank version that I chnage the table to point at to see if that makes a difference.

It now has one row only and it's still VERY slow

Phil_Waite

a row edit took 90 seconds. Here is the audit log

Properties: { "TableName": "Full List table", "tzOffset": "-60", "apiLevel": "2", "isPreview": "true", "checkCache": "true", "locale": "en-GB", "appTemplateVersion": "1.000021", "localVersion": "1.000021", "timestamp": "2022-08-15T18:29:55.999Z", "requestStartTime": "2022-08-15T18:31:53.964Z", "lastSyncTime": "2022-08-15T18:29:38.2593847Z", "appStartTime": "2022-08-15T18:29:43.368Z", "dataStamp": "2022-08-15T18:30:02.771Z", "clientId": "245be5c0-cfee-4f8a-be5a-60daa5a79265", "build": "b0600b40fcc06091b68b-1660551917366-de85e757", "requestId": "57642194", "mechanism": "QuickEdit", "viewName": "USER 60", "AppTemplateVersion": "1.000021", "RowSize": 1509, "AppTemplateName": "10af549a-41ac-4bfd-b35f-87c1781aeb92", "Operation": "Edit row", "RecordType": "Stop", "Errors": "Unable to update row in table 'Full List table'. → Request cancelled: took too long to process: Computing a formula", "ReturnedFromCache": false, "Performance": "{\"Version\":1,\"Time\":\"00:02:00.6610726\",\"PerformanceTimingRoot\":{\"Mid\":154,\"Params\":{\"ParamList\":[{\"Pid\":13,\"Value\":\"Full List table\"}]},\"Timer\":{\"Time\":\"00:02:00.6610726\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":5,\"Timer\":{\"Time\":\"00:02:00.6573818\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":112,\"Timer\":{\"Time\":\"00:02:00.6563904\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":108,\"Timer\":{\"Time\":\"00:02:00.6554066\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":113,\"Timer\":{\"Time\":\"00:02:00.6550281\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":36,\"Timer\":{\"Time\":\"00:02:00.6541203\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":59,\"Timer\":{\"Time\":\"00:00:05.6098058\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":95,\"Timer\":{\"Time\":\"00:00:00.4028375\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":475,\"Timer\":{\"Time\":\"00:00:00.2668648\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":94,\"Timer\":{\"Time\":\"00:00:00.2667842\",\"ElapsedTime\":\"00:00:00\"}}]}]},{\"Mid\":96,\"Timer\":{\"Time\":\"00:00:05.2065081\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":72,\"Timer\":{\"Time\":\"00:00:00.9708724\",\"ElapsedTime\":\"00:00:00\"}},{\"Mid\":69,\"Timer\":{\"Time\":\"00:00:00.2515861\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":498,\"Timer\":{\"Time\":\"00:00:00.2513551\",\"ElapsedTime\":\"00:00:00\"}}]},{\"Mid\":93,\"Timer\":{\"Time\":\"00:00:00.3094381\",\"ElapsedTime\":\"00:00:00\"}},{\"Mid\":68,\"Timer\":{\"Time\":\"00:00:03.6744735\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":83,\"Params\":{\"ParamList\":[{\"Pid\":20,\"Value\":\"1\"}]},\"Timer\":{\"Time\":\"00:00:03.6744600\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":498,\"Timer\":{\"Time\":\"00:00:03.6742536\",\"ElapsedTime\":\"00:00:00\"}}]}]}]}]},{\"Mid\":19,\"Timer\":{\"Time\":\"00:01:55.0434125\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[]},\"Timer\":{\"Time\":\"00:00:00.2629074\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[{\"Pid\":13,\"Value\":\"User Assign Alpha\"}]},\"Timer\":{\"Time\":\"00:00:00.2628986\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":33,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"22\"},{\"Pid\":3,\"Value\":\"17\"}]},\"Timer\":{\"Time\":\"00:00:00.2625032\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":410,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"22\"},{\"Pid\":3,\"Value\":\"17\"}]},\"Timer\":{\"Time\":\"00:00:00.2610353\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":238,\"Timer\":{\"Time\":\"00:00:00.2607164\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":240,\"Timer\":{\"Time\":\"00:00:00.2589606\",\"ElapsedTime\":\"00:00:00\"}}]}]}]}]}]},{\"Mid\":32,\"Params\":{\"ParamList\":[]},\"Timer\":{\"Time\":\"00:00:00.6095476\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[{\"Pid\":13,\"Value\":\"Users\"}]},\"Timer\":{\"Time\":\"00:00:00.6095388\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":33,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"38\"},{\"Pid\":3,\"Value\":\"21\"}]},\"Timer\":{\"Time\":\"00:00:00.6091366\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":410,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"38\"},{\"Pid\":3,\"Value\":\"21\"}]},\"Timer\":{\"Time\":\"00:00:00.5890185\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":238,\"Timer\":{\"Time\":\"00:00:00.5887049\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":240,\"Timer\":{\"Time\":\"00:00:00.5872138\",\"ElapsedTime\":\"00:00:00\"}}]}]},{\"Mid\":15,\"Timer\":{\"Time\":\"00:00:00.0200316\",\"ElapsedTime\":\"00:00:00\"}}]}]}]},{\"Mid\":32,\"Params\":{\"ParamList\":[]},\"Timer\":{\"Time\":\"00:00:04.2076765\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[{\"Pid\":13,\"Value\":\"Running Sheet 2\"}]},\"Timer\":{\"Time\":\"00:00:04.2076693\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":33,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"1\"},{\"Pid\":3,\"Value\":\"7\"}]},\"Timer\":{\"Time\":\"00:00:04.2074758\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":410,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"4\"},{\"Pid\":3,\"Value\":\"7\"}]},\"Timer\":{\"Time\":\"00:00:04.2071110\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":238,\"Timer\":{\"Time\":\"00:00:04.2068682\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":240,\"Timer\":{\"Time\":\"00:00:04.2067812\",\"ElapsedTime\":\"00:00:00\"}}]}]}]}]}]},{\"Mid\":32,\"Params\":{\"ParamList\":[]},\"Timer\":{\"Time\":\"00:00:18.3917546\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[{\"Pid\":13,\"Value\":\"Filterlist\"}]},\"Timer\":{\"Time\":\"00:00:18.3917454\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":33,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"23\"},{\"Pid\":3,\"Value\":\"20\"}]},\"Timer\":{\"Time\":\"00:00:18.3914678\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":410,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"23\"},{\"Pid\":3,\"Value\":\"20\"}]},\"Timer\":{\"Time\":\"00:00:18.3897431\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":238,\"Timer\":{\"Time\":\"00:00:18.3895048\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":240,\"Timer\":{\"Time\":\"00:00:18.3875070\",\"ElapsedTime\":\"00:00:00\"}}]}]}]}]}]},{\"Mid\":404,\"Params\":{\"ParamList\":[{\"Pid\":1,\"Value\":\"Delivery Area\"}]},\"Timer\":{\"Time\":\"00:00:34.0932660\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[]},\"Timer\":{\"Time\":\"00:00:34.0929177\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[{\"Pid\":13,\"Value\":\"Call Signs\"}]},\"Timer\":{\"Time\":\"00:00:34.0929063\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":33,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"44\"},{\"Pid\":3,\"Value\":\"5\"}]},\"Timer\":{\"Time\":\"00:00:34.0927263\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":410,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"44\"},{\"Pid\":3,\"Value\":\"5\"}]},\"Timer\":{\"Time\":\"00:00:34.0919081\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":238,\"Timer\":{\"Time\":\"00:00:34.0915734\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":240,\"Timer\":{\"Time\":\"00:00:34.0902711\",\"ElapsedTime\":\"00:00:00\"}}]}]}]}]}]}]},{\"Mid\":404,\"Params\":{\"ParamList\":[{\"Pid\":1,\"Value\":\"Last Delivery Date\"}]},\"Timer\":{\"Time\":\"00:00:00.8789568\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[]},\"Timer\":{\"Time\":\"00:00:00.8787075\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[{\"Pid\":13,\"Value\":\"Orders\"}]},\"Timer\":{\"Time\":\"00:00:00.8786961\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":33,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"0\"},{\"Pid\":3,\"Value\":\"0\"}]},\"Timer\":{\"Time\":\"00:00:00.8771384\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":410,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"0\"},{\"Pid\":3,\"Value\":\"0\"}]},\"Timer\":{\"Time\":\"00:00:00.8653525\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":97,\"Params\":{\"ParamList\":[{\"Pid\":17,\"Value\":\"DocId=1sC8qnjKf7O1ZbtcVoeTmk1z15W_Z8494sgl5Kk20weQ\"}]},\"Timer\":{\"Time\":\"00:00:00.2598223\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":458,\"Timer\":{\"Time\":\"00:00:00.2590943\",\"ElapsedTime\":\"00:00:00\"}}]},{\"Mid\":238,\"Timer\":{\"Time\":\"00:00:00.6051715\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":240,\"Timer\":{\"Time\":\"00:00:00.6051647\",\"ElapsedTime\":\"00:00:00\"}}]}]},{\"Mid\":15,\"Timer\":{\"Time\":\"00:00:00.0116835\",\"ElapsedTime\":\"00:00:00\"}}]}]}]}]},{\"Mid\":404,\"Params\":{\"ParamList\":[{\"Pid\":1,\"Value\":\"Last Delivery Date ---/---Price List --- /--- Beer Buyer Spoken to\"}]},\"Timer\":{\"Time\":\"00:00:02.9551652\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[]},\"Timer\":{\"Time\":\"00:00:02.9444889\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[{\"Pid\":13,\"Value\":\"Call Logger\"}]},\"Timer\":{\"Time\":\"00:00:02.9444793\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":33,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"8351\"},{\"Pid\":3,\"Value\":\"15\"}]},\"Timer\":{\"Time\":\"00:00:02.9440436\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":410,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"8387\"},{\"Pid\":3,\"Value\":\"15\"}]},\"Timer\":{\"Time\":\"00:00:02.9113652\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":238,\"Timer\":{\"Time\":\"00:00:02.9077834\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":240,\"Timer\":{\"Time\":\"00:00:02.8257978\",\"ElapsedTime\":\"00:00:00\"}},{\"Mid\":239,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"8387\"},{\"Pid\":3,\"Value\":\"15\"}]},\"Timer\":{\"Time\":\"00:00:00.0713342\",\"ElapsedTime\":\"00:00:00\"}}]}]},{\"Mid\":15,\"Timer\":{\"Time\":\"00:00:00.0325589\",\"ElapsedTime\":\"00:00:00\"}}]}]}]}]},{\"Mid\":404,\"Params\":{\"ParamList\":[{\"Pid\":1,\"Value\":\"Related Billing Address\"}]},\"Timer\":{\"Time\":\"00:00:35.5409126\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[]},\"Timer\":{\"Time\":\"00:00:35.5407349\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[{\"Pid\":13,\"Value\":\"Billing Address\"}]},\"Timer\":{\"Time\":\"00:00:35.5407220\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":33,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"3\"},{\"Pid\":3,\"Value\":\"84\"}]},\"Timer\":{\"Time\":\"00:00:35.5401195\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":410,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"3\"},{\"Pid\":3,\"Value\":\"84\"}]},\"Timer\":{\"Time\":\"00:00:35.5069008\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":238,\"Timer\":{\"Time\":\"00:00:35.5065405\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":240,\"Timer\":{\"Time\":\"00:00:35.5062562\",\"ElapsedTime\":\"00:00:00\"}}]}]},{\"Mid\":15,\"Timer\":{\"Time\":\"00:00:00.0331359\",\"ElapsedTime\":\"00:00:00\"}}]}]}]}]},{\"Mid\":404,\"Params\":{\"ParamList\":[{\"Pid\":1,\"Value\":\"Related Call Logs\"}]},\"Timer\":{\"Time\":\"00:00:00.0514561\",\"ElapsedTime\":\"00:00:00\"}},{\"Mid\":404,\"Params\":{\"ParamList\":[{\"Pid\":1,\"Value\":\"Related Data Imports\"}]},\"Timer\":{\"Time\":\"00:00:00.4458377\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[]},\"Timer\":{\"Time\":\"00:00:00.4455897\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[{\"Pid\":13,\"Value\":\"Data Import\"}]},\"Timer\":{\"Time\":\"00:00:00.4455798\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":33,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"2\"},{\"Pid\":3,\"Value\":\"37\"}]},\"Timer\":{\"Time\":\"00:00:00.4446889\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":410,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"1046\"},{\"Pid\":3,\"Value\":\"37\"}]},\"Timer\":{\"Time\":\"00:00:00.4220645\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":97,\"Params\":{\"ParamList\":[{\"Pid\":17,\"Value\":\"DocId=1PzW2YeRNcg0-F1-l6L4FFIt47VDNQ3RWsLpbwEdexCc\"}]},\"Timer\":{\"Time\":\"00:00:00.0090972\",\"ElapsedTime\":\"00:00:00\"}},{\"Mid\":238,\"Timer\":{\"Time\":\"00:00:00.4115644\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":240,\"Timer\":{\"Time\":\"00:00:00.4065564\",\"ElapsedTime\":\"00:00:00\"}}]}]},{\"Mid\":15,\"Timer\":{\"Time\":\"00:00:00.0225232\",\"ElapsedTime\":\"00:00:00\"}}]}]}]}]},{\"Mid\":404,\"Params\":{\"ParamList\":[{\"Pid\":1,\"Value\":\"Related Email Shot Lists\"}]},\"Timer\":{\"Time\":\"00:00:12.2150659\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[]},\"Timer\":{\"Time\":\"00:00:12.2131851\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[{\"Pid\":13,\"Value\":\"Email Shot List\"}]},\"Timer\":{\"Time\":\"00:00:12.2131723\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":33,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"3768\"},{\"Pid\":3,\"Value\":\"12\"}]},\"Timer\":{\"Time\":\"00:00:12.2126807\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":410,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"3768\"},{\"Pid\":3,\"Value\":\"12\"}]},\"Timer\":{\"Time\":\"00:00:12.2060844\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":238,\"Timer\":{\"Time\":\"00:00:12.2053681\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":240,\"Timer\":{\"Time\":\"00:00:12.1980304\",\"ElapsedTime\":\"00:00:00\"}},{\"Mid\":239,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"3768\"},{\"Pid\":3,\"Value\":\"12\"}]},\"Timer\":{\"Time\":\"00:00:00.0050037\",\"ElapsedTime\":\"00:00:00\"}}]}]},{\"Mid\":15,\"Timer\":{\"Time\":\"00:00:00.0064678\",\"ElapsedTime\":\"00:00:00\"}}]}]}]}]},{\"Mid\":404,\"Params\":{\"ParamList\":[{\"Pid\":1,\"Value\":\"Related Order Details\"}]},\"Timer\":{\"Time\":\"00:00:00.5466330\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[]},\"Timer\":{\"Time\":\"00:00:00.5462466\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[{\"Pid\":13,\"Value\":\"Order Details\"}]},\"Timer\":{\"Time\":\"00:00:00.5462391\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":33,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"1\"},{\"Pid\":3,\"Value\":\"54\"}]},\"Timer\":{\"Time\":\"00:00:00.5456141\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":410,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"1\"},{\"Pid\":3,\"Value\":\"54\"}]},\"Timer\":{\"Time\":\"00:00:00.5416316\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":238,\"Timer\":{\"Time\":\"00:00:00.5413178\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":240,\"Timer\":{\"Time\":\"00:00:00.5411529\",\"ElapsedTime\":\"00:00:00\"}}]}]}]}]}]}]},{\"Mid\":404,\"Params\":{\"ParamList\":[{\"Pid\":1,\"Value\":\"Related Reminders\"}]},\"Timer\":{\"Time\":\"00:00:01.5543983\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[]},\"Timer\":{\"Time\":\"00:00:01.5541837\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[{\"Pid\":13,\"Value\":\"Reminders\"}]},\"Timer\":{\"Time\":\"00:00:01.5541766\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":33,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"1\"},{\"Pid\":3,\"Value\":\"12\"}]},\"Timer\":{\"Time\":\"00:00:01.5539567\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":410,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"1\"},{\"Pid\":3,\"Value\":\"12\"}]},\"Timer\":{\"Time\":\"00:00:01.5532894\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":238,\"Timer\":{\"Time\":\"00:00:01.5529341\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":240,\"Timer\":{\"Time\":\"00:00:01.5528664\",\"ElapsedTime\":\"00:00:00\"}}]}]}]}]}]}]},{\"Mid\":404,\"Params\":{\"ParamList\":[{\"Pid\":1,\"Value\":\"Related Websites\"}]},\"Timer\":{\"Time\":\"00:00:03.2861997\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[]},\"Timer\":{\"Time\":\"00:00:03.2692190\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":32,\"Params\":{\"ParamList\":[{\"Pid\":13,\"Value\":\"Web Link\"}]},\"Timer\":{\"Time\":\"00:00:03.2692104\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":33,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"24789\"},{\"Pid\":3,\"Value\":\"6\"}]},\"Timer\":{\"Time\":\"00:00:03.2689871\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":410,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"24791\"},{\"Pid\":3,\"Value\":\"6\"}]},\"Timer\":{\"Time\":\"00:00:03.1991300\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":238,\"Timer\":{\"Time\":\"00:00:03.1946685\",\"ElapsedTime\":\"00:00:00\"},\"Children\":[{\"Mid\":240,\"Timer\":{\"Time\":\"00:00:02.8996514\",\"ElapsedTime\":\"00:00:00\"}},{\"Mid\":239,\"Params\":{\"ParamList\":[{\"Pid\":9,\"Value\":\"24791\"},{\"Pid\":3,\"Value\":\"6\"}]},\"Timer\":{\"Time\":\"00:00:00.2833705\",\"ElapsedTime\":\"00:00:00\"}}]}]},{\"Mid\":15,\"Timer\":{\"Time\":\"00:00:00.0697630\",\"ElapsedTime\":\"00:00:00\"}}]}]}]}]}]}]}]}]}]}]}]},\"IsEmpty\":false,\"CategorizedTimings\":{},\"TableAttributionTimings\":{}}", "Result": "Failure" }

Phil_Waite

Hi have one that tookm 12o seconds and timed out. How do I found out which formula took too long to compute?

Steve

Please contact AppSheet Support for help with this.

Edits VERY slow to save again with errors in performance profile