Update/insert in chunks?

Update/insert in chunks?

El Forum
Guest

#22

02-14-2009, 09:08 PM

[eluser]codex[/eluser]
[quote author="TheFuzzy0ne" date="1234688429"]Right. OK then, scrap that idea...

What's the average size of the files you need to work with?[/quote]

The files differ greatly in size, but the largest I have come across is more than 80mb (167.000 products). I think I only need to deal with 10mb files max.

The temp table after insert of the 6000 records is approx. 4mb.

Messages In This Thread

Update/insert in chunks? - by El Forum - 02-14-2009, 07:55 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 08:02 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 08:06 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 08:25 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 08:28 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 08:30 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 08:32 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 08:33 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 08:35 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 08:37 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 08:44 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 08:45 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 08:48 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 08:50 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 08:52 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 08:53 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 08:55 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 08:58 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 08:59 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 09:00 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 09:08 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 09:13 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 09:22 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 09:23 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 09:26 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 09:43 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 09:44 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 09:46 PM

Update/insert in chunks? - by El Forum - 02-14-2009, 11:10 PM