You are here:  » Updating feeds, making new IDs in database

Support Forum



Updating feeds, making new IDs in database

Submitted by Andrewc on Wed, 2009-07-15 08:32 in

Just wondering about this..

When updating a feed it removes the old rows from the Products table then adds new ones.
So the IDS are all new ones..

Is this not an issue later on when having a million products and the the ID number becomes to big for the ID column structure?

Would it be better to simply update the current row in the products table?

Submitted by support on Wed, 2009-07-15 08:40

Hi Andrew,

It shouldn't be a problem, but in the event that it did happen, using import.php @ALL (which TRUNCATEs the products table) would resolve it. Unfortunately updating rows rather than a simple DELETE / re-INSERT would make importing too slow and processor intensive on large sites...

Cheers,
David.

Submitted by Andrewc on Wed, 2009-07-15 08:48

Good point.. thanks for clearing this up for me.