Re: Copying tables

Posted in 1997

"Billy Wheeler" — 4 Aug 1997 10:18:07 -0400 — source: Informix-list mailing list archive (1991-1998)

On 4 Aug 97 at 11:11, Kevan wrote: > We currently have a system that involves two Informix databases, a > local Online 7 database and a remote Online 5 database. Because of > this remote connection we want to periodically take copies of > certain highly accessed tables on the remote system so that we > 'cache' them locally. While the duplication is taking place we > cannot stop local read access to the cached table. Firstly, DROPping the local table will be much quicker than a DELETE if you want to get rid of all the records in your local tables. Secondly, try out the hi performance loader (it might require a version upgrade to 7.22 or greater.) Also, remember to create your indexes *after* you load the data. HTH. -- Ciao, Billy Nose to the ear in Johannesburg, Murder Capital of the World.