FN-FORUM: mySQL/php question

date posted 27th February 2008 22:48

Hi all,

Maybe a bit late in the day to ask this one, but I have a question about a
php function that I had made up for me to copy some Joomla DocMan content to
Virtumart, thing is that the tables are now pretty big and the script is
becoming extremely slow and tends to time out.

I know I could increase the script processing time but I'm hoping I have an
alternative, I've pasted the function below and was hoping someone could
point me in the right direction so that rather than going through every
record (which is why its taking so long) can I modify the code to start
processing from a specific record ID, in this way I'm hoping that the
process will be a lot quicker, and once a week I can modify the script so
that things run smoothly - not exactly ideal I know, but I am getting a new
component built which will automate all this but its gonna take a couple of
months probably.

Anyway, if anyone can help me out I'd be grateful.

Thanks in advance

Allan


function pruneVm() {

global $database;

$sql = "SELECT * FROM #__docman d";
$database->setQuery($sql);
$doc = $database->loadObjectList();
$k=0;
for($i=0;$iid."'";

$database->setQuery($sql);

$product_id = $database->loadResult();

if(!$product_id) {

saveToVm($doc[$i]);
$k++;

}

}
mosRedirect("index2.php?option=com_docman§ion=documents", "$k
document(s) copied to virtue mart");
exit;


}