You were right. When running the script with another way of fetching, the
memory usage stays low.

When doing something like:

$query = $dbh->prepare("SELECT * FROM mytable WHERE id=? && name=?");
.....
in that while loop i now do:
$query->execute($id, $name);
if($hash_ref = $query->fetchrow_hashref) {
 ## do an update on mytable
} else {
 ## do an insert into mytable
}
$query->finish();

Does it hereby clear out the memory for that hash reference or does it keep
it even after the finish() ?

Groetjes,
Tiele Declercq [ [EMAIL PROTECTED] ]

---

Projectleider Start.be
http://start.be


Reply via email to