Do any of the tables have a large number records? I have noticed recently that large tables (e.g. 20 million records) are very slow with DISTINCT VALUES even on indexed fields with a relatively small number values. For example on a big table and selection of 14,000 records DISTINCT VALUES only takes about 25 ms. But if the selection is 15,000 or a little more it suddenly jumps to about 3500 ms.
4D reports the table is not fragmented. I have not tried compacting or rebuilding indexes yet. You might give this a try to see if it makes a difference. I don't use RELATE MANY, but recently verified the same problem with DISTINCT VALUES impacts RELATE ONE SELECTION. 4D's built in progress dialog pops up with a message such as "computing distinct values". John DeSoi, Ph.D. > On Jun 28, 2017, at 6: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. ********************************************************************** 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] **********************************************************************
