The need for speed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

(me again) - now i have finally launched my aplication in a run time enviroment. But in my final testing the classic problem shows up, the need for speed. I`ve split my database in three parts; adm, data source and end user. All the tables that dosent change i`ve places locally the other tables are linked to my datasource database. This is on a network. Some of my forms launch very slow. Funny enough my smallest front end is the slowest. I have ca 25 different users who are logged in at different times, max 5 users are execpected to be logged in at the same time.

Does anyone have some tricks to speed things up, or know some classic things to do/look for to make this go a litle faster..

Thank you very much

Erik
 
Eric,

I had similar problems and found a reference somewhere in these newsgroups
to a site (must have been some MVP's site, I think) with performance tips,
two of which made a world of difference to the performance of my split
multi-user .mdb's... but, for the life of me, I haven't been able to find it
again! So don't shoot, not claiming credit for those tips. If anyone knows
this site, pls post it here for the benefit of all...

Anyway, the two tips in short: (a) in your back-end, set the subdatasheet
property of all tables to none, and (b) in the front end, use a couple of
lines of code to establish a link to the BE on open, and keep it like that
until the BE is closed (so the link is always open). One way to do this is
to add a dummy one-record table to the BE and open a recordset on it on FE
open (and close on exit).

HTH,
Nikos

Erik said:
Hi,

(me again) - now i have finally launched my aplication in a run time
Click to expand...
enviroment. But in my final testing the classic problem shows up, the need
for speed. I`ve split my database in three parts; adm, data source and end
user. All the tables that dosent change i`ve places locally the other tables
are linked to my datasource database. This is on a network. Some of my forms
launch very slow. Funny enough my smallest front end is the slowest. I have
ca 25 different users who are logged in at different times, max 5 users are
execpected to be logged in at the same time.
Does anyone have some tricks to speed things up, or know some classic
Click to expand...
things to do/look for to make this go a litle faster..
 
Hi!

Thanks so much.. ive found much on the site that im going to trye out.. will report back on which method im using and how it worked out. For so long.. thank you again.

Erik
 
ok, i now got speed. The simplest way did the trick - i yest hold a hidden form bound to one of the linked tables.. and woila.. my need for speed is satisfied..

Erik
 
Back
Top