CDR with many tables
Posted in 2005
malc_p@btinternet.com — — source: Usenet: comp.databases.informix
IDS9.30HC5; HP-UX11i This is actually a follow-up to my previous regarding deferred level-1 restores, and is associated with the resultant "HDR not allowing blobspaces" threads. I know CDR allows blobs and I know it works because I've done some testing previously. But...... CDR requires a separate definition for every table in every database you want to replicate. I have scripted the process and that is also no problem. What I wondered was, how would CDR cope with upwards of 650 tables defined in an OLTP system? We can get through 50 x 10Mb logs an hour at peak times.... Network capacity isn't a problem though. Anyone doing CDR with lots of tables? Cheers Malc