Moving data between tables

-drew at sautins@coralsys.com writes: > My question is, what is the best way of moving data >from one table to another in the fastest possible manner? >I've heard about detaching and attaching fragments from one >table to another, but our problem seems to be that the processing >can fall behind the population, so using a set number of fragments >may not be possible. Can I attach a table to another? Is there >another solution? Sounds like an interesting topic, I'd like to hear more. Here's my spin: You might be able to play around with synonyms [spelling?]. Start with two identical tables A & B. Two programs prog_input.4ge works on table X prog_procs.4ge works on table Y. Start have X point to A have Y point to B prog_input.4ge will populate table A prog_procs.4ge will process table B [then clear table B when done] Switch [possible Sub-second interuption in prog_input.4ge] have X point to B have Y point to A prog_input.4ge will populate table B prog_procs.4ge will process table A [then clear table A when done] Goto Start -- || ======= **** **T* ======= ||John Regep || **** **** ||Kmart Information Systems || **** *R** ||Kmart Corporation || =========== ********* =========== ||3100 West Big Beaver C-1 || ***A* **** ||Troy, MI 48084 || **** **** ||(810) 643-5078 ||=============== *M** **** ===============||uunet!kmart!jregep