Fe/Be split seems to slow things down

  • Thread starter Thread starter Simon Webb
  • Start date Start date
S

Simon Webb

I have split my project into a Front End / Back End.

Many operations now take 4+ times as long (I have an audit function which
records how long some processes take).

Can the FE/BE split slow things down or should I look for another cause (the
FE & BE are in the same directory on the same PC).

Thanks in advance

Simon
 
Simon said:
I have split my project into a Front End / Back End.

Many operations now take 4+ times as long (I have an audit function
which records how long some processes take).

Can the FE/BE split slow things down or should I look for another
cause (the FE & BE are in the same directory on the same PC).
Click to expand...

When running on a local disk yes, a split app is slower than a non-split
app. I wouldn't expect "4 times as long" to apply, but there is somewhat of
a penalty. However; running a split app where the front end is local and
the back end is on the LAN somwhere should be faster then running a
monolithic file over the LAN or a split app where the front end is not
local.
 
The penalty due to split is usually VERY minor in most cases.

However, to restore your performance, when the application loads, have it
open a table to the back end (any table). YOU MUST KEEP this table open
during operation of the rest of the application. If you do this, your
performance will be restored.

Try the above..and then post back here on the results....
 
Yes this makes a big difference, and for the original poster create a form
make this form open when the application is open, bind this form to one of
the linked tables and make the form hidden, so it is running in the
background all the time.
 
Back
Top