Eric, How long does a query on the related field take? Any picture or blob fields in the related table? Those could slow down the loading of the related records.
> On Jun 28, 2017, at 5:59 PM, Eric Naujock via 4D_Tech <[email protected]> > wrote: > > I have been trying to do some performance tuning an optimizing on one of my > 4D databases and am finding that one function RELATE MANY is taking over 1790 > ms. At lease are there any 4d Tools that are available to help analyze the > case of tis timeout and resolve the issue. I have tried adjusting the indexes > on the related records but that does not seem to help. > > It would be useful to have a function or a way to find out what the database > is doing when the functions run to find out why the function takes so long to > run. Any suggestions on tools to help solve this problem. > > I tried the analyze query command but that did not tell me anything. So far > al I have tis the debug log to try to help guide where my slowdowns are but > that is rather tedious. > > ----------------------------------------------------------------------- > > MacCafe > 4405 Talmadge St. > Toledo, OH 43623 > Eric Naujock - ACSA 10.2, 10.3, 10.4 Apple - ACTC 10.5, 10.6, 10.7, 10.8, > 10.9, 10.10 > http://www.mac-cafe.com > email: e <mailto:[email protected]>[email protected] > <mailto:[email protected]> > AOL IM: erlic > Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 974-8538 hardware, installation, training, support, programming, internet specializing in 4th Dimension =-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= "Microsoft is a cross between the Borg and the Ferengi. Unfortunately, they use Borg to do their marketing and Ferengi to do their programming." -- Simon Slavin ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
