Home » RDBMS Server » Performance Tuning » replication or not ?
replication or not ? [message #65301] Mon, 26 July 2004 11:31
dieter
Messages: 17
Registered: February 2002
Junior Member
i have the following scenario:

two separated locations connected with a 2 MBit VPN connection over the internet. one location (main) hosts the database server and the other location (remote) needs to insert and retrieve large (up to 100 MB) documents stored in LOBS. the insert and retrieval of the documents is very slow and so i was thinking to use snapshot based replication into a local database and only later refresh the master table in the main database.

does someone have experience with this type of problem and would be able to share his experience ?
Previous Topic: Character Set scanner.plz help
Next Topic: Database slow down at particular time
Goto Forum:
  


Current Time: Thu Mar 28 09:15:27 CDT 2024