well typicly the server should be the computer with the most power so
searching on the server should be much faster as on the client
also how big will this master file be ?? , how about data synchronization to
the client ?? ( user a changes something in the master db , if user b
connected before these changes were applied he will not see this changes )
if we are talking about small amounts of data , ( i.ow. fast method of
fetching the complete updated database ) you could ( again ) choose for a
smart data client aproach
create a trigger in your database that will change a value( guid ) when a
update / insert / delete takes place on the table on startup retrieve all
data and now poll the database once in while to see if there was a
alteration on the master table ( so you know you should retrieve the new
dataset )
if you are so lucky that you use SQL 2000 or better SQL 2005 you may
investigate notification services ,,,, ( with this it is possible for your
app to subscribe to a dataset for notifications on that dataset , basicly a
callback event to your app takes place whenever such an event occurs )
regards
Michel Posseth [MCP]
"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:Ob**************@TK2MSFTNGP15.phx.gbl...
My client got branch in some small city, their network connection is not
stable.
He suggest us to change the application" each time user login the system,
it will automically d/l the master file into his workstation', so, the
querry or searching can be performed in local pc, If the user want to
update the account record, It will connect the sql server (located in data
centre) and update the data.
Does anyone got some idea on it ??
Thanks in advance.
(it seems offline application, but it is not a web form, the application
is run in vb.net)