On networked access app. How does sorting happen?

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

Guest

I have an Access application. I use many tables just for sorting data. Most
of what I call sort tables are initialized (data deleted) prior to the sort.
Does it matter if I place the sort tables on the local drive instead of on
the network where the other data is? I'm thinking speed. .. will the
query/sort happen faster if the data is sorted via an update/append query
where the table is on the user's local hard drive instead of the network
drive? Or will the sort happen in the actual network drive quicker because
less data is sent accross the network cable? Thanks
 
Hi,


With Jet, the query is executed on the PC asking about the data, so the
PC probably got the index, in any was relevant.


In general you will use a table on the local HD if you want data to not
be shared with other users, since as soon as it is local, it is unaware of
other users, and if other user delete/add some records you just locally
stored, that won't be synchronized in your copy. On the other ends, it has
its use, like allowing the particular user to tag (select) some records, say
to tag which companies, are to be included in the report to be produced,
next. If the "tag" is a field in the table, you don't want that table
"global", in case 2 different users are trying to produce the same report,
but with different "selected" companies... It is not a question of timing as
much as a question of logic about the job to be done, in such case.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top