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:e...@mac-cafe.com>r...@mac-cafe.com <mailto:e...@mac-cafe.com> AOL IM: erlic ********************************************************************** 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:4d_tech-unsubscr...@lists.4d.com **********************************************************************
