Performance in a Network

[VBITS]

I have a database which has got a front-end and a backend, both on other computers in a network.

When opening a form (and requesting the backend for data) I noticed like 300K was received from the server for a 8x3 table (integers and text only).

This is probably caused by Access which isn't consistent in requesting data (It will call the whole table just for one field)

Does anyone know a workaround so I only need to load a datasheet/recordset once, so when I need to fill a combo, the data is allready in the memory of the client app?

 

[pono1]

As a supplement to Pat's post: If you use local tables to cache your data and you are deleting and replacing recs every time your app loads, to avoid bloat be sure to compact the front-end on close. Also, if you don't want to take the time to cache (and synchronize with your BE), say, info in a combo box, leave the combo's row source empty until the user clicks the thing -- at that point set the row source in code. This may result in slightly faster form loads, though, yes, it may also result in a slight pause when first clicking the combo. Getting good performance is always a bit of a juggling act.

Lastly, this may or may not apply to your specific situation, but generally you will want to index a field used in the criteria of a query.

Regards,
Tim

 

[VBITS]

Well, I also thought off ways to syncro... As the machines which use the FE are all high memory machines (at least 512 MB), I thought off the following, exept I come to a point where I cannot get further. Can anyone help me out?

- When opening the FE a Mod Declares X Recordsets (Where X is equal to the number of frequently used tables) so I come out with many public recordsets (pRstTablename )
- I want to link all the forms combo's etc to those recordsets, which should be updated when leaving the FE
- Only problem is: I can create a recordset, but I have a problem linking those (for the form local recordsets) to a combo, it keeps on saying the types do not match...

Ideas?

Tnx In advance

 

[VBITS]

By the way, Indexes where the first thing I checked, but still the bloody FE pulls like 300K's for a simple form having 4 fields