disadvantage or advantage?

[zhongwei]

Hi,all
I had planed to link my local database to a remote database,since the remote database is in multiuser enviroment if it corrupted (it has corrupted twice before) it may affect my local database.I change my mind ,I try to add query in remote database when it send data to database,it also send same data to my local database.but I,m not sure this thought is good or not,Could anyone tell me the disadvantage or advantage of it?

 

[rorymurray]

I'm assuming you just want to view the data on the remote database?

Depending on how long the query takes to export the data versus how many times you want to access the data is what you have to decide.

If the export query doesn't take very long to run I would do it that way, then at least you don't have to worry about connecting to the remote database every time you want to view some data.