1 Reply Latest reply on Feb 19, 2013 8:25 AM by philmodjunk

    Portal Performance FM11 VS FM12



      Portal Performance FM11 VS FM12


           My database performance upgrading to 12 the speed and performance in sorting and searching has been dismal.   I have a main TO with 8 Tabs linking portal information inventory etc. since upgrading to 12 if I select a tab the spinning dial appears and the function takes close to 5 seconds to bring the information forward where in  FM11 the display is immediate? Any ideas about this where I should start to look to improve performance? 


        • 1. Re: Portal Performance FM11 VS FM12

               FileMaker 12 is slower than 11 across the board. The bug fix updates have helped, but 12 is still slower than 11.

               Are the portals filtered? If you incorporate the filtering logic at the relationship level, the portals often update much faster.

               Do the relationships use inequality operators? If so and you are using them to define a range of matching values, you might be able to replace the inequality operators with a return separated list of values.

               Any of these portals "read only"? If so, you might be able to toss the portal and replace it with a large calculation field that uses ExecuteSQL to list rows of related data. You can specify the pilcrow (return operator) as the record separator and the tab character as the field separator and then use the appearance settings to set tab stops. YOu can even give the field a scroll bar.

               I don't really know if this last option will result in a performance improvement--it can result in a much simpler relationship graph, but it might be worth a try to see if it makes a sifference.