Large Database Easy Populate and Backup Problem Fix

[Guest]

Hi all,

I have been having this problem for months where trying to download tab delimited file , froogle file, or what ever with Easy Populate would fail. As well as doing a backup would fail. This all started when my products got to about 3000 items. Well thanks to Corey of my hosting company he figured it out and both work for me and Im a very happy person. It seems that since the processes take longer the browsers are not getting a reply and disconnecting from the server. So the fix was to put print " "; in. This kept data going to the browser and let the jobs finish. So in Easy Populate it would be:

$num_of_langs = count($langcode);

while ($row){

 print " ";

 // if the filelayout says we need a products_name, get it

 

Or in Backup.php it would be:

 while ($tables = tep_db_fetch_array($tables_query)) {

print " ";

         list(,$table) = each($tables);

The backup one will go to a blank page when done but does finish. Im sure there is a better way but I came up with that one once my guy did the one for easypopulate.php

Anyway just thought I would pass the info along.