Hello everyone, While I still have plans to do some more work on RServ, it is apparent to me that I need a more immediate solution. I'm not replicating my entire dataset, but rather just some "summary" tables that are maintained by stored procedures. This means RServ is an iffy proposition at best for me right now.
So, I'm looking at syncronizing 4 tables from one master database to several child databases. I'm thinking of doing the following with DBD::Multiplex: DELETE FROM TableA; INSERT INTO TableA (..) VALUES (...); .... on all the child databases, but I'm not sure what kind of impact this would have on my servers. My impression is that this would hammer the indexes, and might blow any memory optimization out the window. Only a few records in my dataset will change from time-to-time, but just the process of determining what is different may take more effort than simply rebuilding. What are your thoughts? These tables will probably only have a maximum of 10,000 rows in total, but I'm going to have to syncronize once per minute; as a result, I wouldn't like this to take any longer than about 10 seconds. -- /* Michael A. Nachbaur <[EMAIL PROTECTED]> * http://nachbaur.com/pgpkey.asc */ "Out," he said. People who can supply that amount of firepower don't need to supply verbs as well. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
