[RESOLVED] Copying a table to another

[meigwil]

Hi,

I'm in the process of streamlining an app I wrote a while ago.

The biggest problem is copying data from a table in an external database to my own. I need to copy the data so I can process it in my own way. The old table and new tables are of different structures, and thus I have loads of database queries. I take 6 records from the old table and put them all in one record in the new table.

The present system is simply to empty the new table, and then copy and write all the data. After a while this operation was taking over a minute to complete.

So I need to optimise it so it checks the new table, compares with the old, and only copy and write what's needed.

Has anyone any ideas? Or am i completely vague? Please ask me for more details if needed.

Thanks,

Mei

[meigwil]

Please ignore this. I actually put my head down and thought about it, which seemed to work.

Mei ;-)