melastudio

FM12 Speed

Discussion created by melastudio on Mar 20, 2013
Latest reply on Mar 21, 2013 by gdurniak

After the release of FM12 many Threads have been written complaining the lower speed of v12 against v11.

It's no longer so!

 

I'd like to post my recent experience with the migration of a .fp7 solution (built between FM7 and FM9) to FM12.

The Database is on LAN, 5 users, over 300Mb of database with many, many tables, scripts, fileds and a complex relashionship graph.

 

I tested in parallel using the same client with both version of FM11 and 12 on the same LAN: the standard server 11 (mini intel core 2 duo) and a test FMS12 (on my Air 2011) via WIFI.

 

I know: 2 mac very different, the Air faster but the wifi compensates a little

 

In a moment with no trafic I've made se same identical operation on the same data (immediately after conversion of the DB, rebulding index). Despite the WIFI connection my speed on complex script (such as loop beetween records) was better on FM12 (from 30% to 100%). To repeat the operatione gave FM12 even more speed...

I've tried a specific task that downloads from server a lot of information, sorts and summarizes them and in this case FM11 was faster giving me the confirm that the WI-FI connection is a big bottleneck.

 

I was expecting a collapse of the performance but tests said the opposite.

 

So I've tried the migration and performances are very better than before. Also in listing many records with conditional formatting (I remember was terrifying on the first release of FM12)

:-)

 

I think that all the update to server and client in this year has improved fm12 performance to a pleasant level.

Do you agree with me?

 

P.S

Next step will be an hardware upgrade in order to take advantage of 64 bit (multicore and more RAM)

Outcomes