How to edit huge amount of records and pics in SQL
===

I have an old table with thousands of posts. Each post have 0-4 link to pictures, about a product. Now I have to use the data in the old table to crate a new, and to move the pictures into different folders. I also have to create thumbnails for every picture.

This task sound me a big job, with a long runtime. Should I write the code for this only in a single .php file, than just let the server to run it, or there is a special technique for this. All in all how can you work with huge tables and tons of pics via php?