save resources *sql_query and array size

[Tom Asken]

Hello,

i could not find information about extracting data by using
*sql_query (for me mssql_query) and do that in a way that saves server
memory.

I usually use:

$sql = "exec sp_get_GremiumsMitglieder
@foo = 'myFoo',
@bar = 42";

$rsResult = mssql_query($sql);
$i=0;
while($data = mssql_fetch_array($rsResult))
{
extract($data);
$mitglieder[$i] = array("id" => $id, "displayName" => $displayName,
"eMail" => $eMail, "authuser" =>
$authuser);
$i+=1;
}

So the result is an array half the size; instead of $mitglieder[0] and
$mitglieder[id] there is just $mitglieder[id].

Is there a better way. How can i free memory for Variables that are no
longer used (sql, rsResult, i). I sometimes read something about die()
/ exit() but the online documentation on php.net did not say anything
that would led to belive that memory is freed.

Is there a necessity / advantage to close the connection to
sql-server?
Thanks a lot

Tom Asken

[Alvaro G Vicario]

*** Tom Asken wrote/escribió (27 Apr 2004 03:48:42 -0700):

while($data = mssql_fetch_array($rsResult))
{
extract($data);
$mitglieder[$i] = array("id" => $id, "displayName" => $displayName,
"eMail" => $eMail, "authuser" =>
$authuser);
$i+=1;
}

So the result is an array half the size; instead of $mitglieder[0] and
$mitglieder[id] there is just $mitglieder[id].
You have just reinvented mysql_fetch_assoc(), haven't you?

I guess the best way to save memory is using data while reading it and
afterwards unsetting results. Your code makes a copy of the complete
results so you actually get data twice in memory.
Is there a better way. How can i free memory for Variables that are no
longer used (sql, rsResult, i).
Maybe unset()
I sometimes read something about die()
/ exit() but the online documentation on php.net did not say anything
that would led to belive that memory is freed.

With die and exit the execution of the script is terminated. If that
doesn't release memory then I don't think you could blame your script.

--
--
-- Álvaro G. Vicario - Burgos, Spain
--

[Chris Hope]

Alvaro G Vicario wrote:

*** Tom Asken wrote/escribió (27 Apr 2004 03:48:42 -0700):

while($data = mssql_fetch_array($rsResult))
{
extract($data);
$mitglieder[$i]*=*array("id"*=>*$id,*"displayName"*=>*$displayNam e,
"eMail"*=>*$eMail,*"authuser"*=>
$authuser);
$i+=1;
}

So the result is an array half the size; instead of $mitglieder[0] and
$mitglieder[id] there is just $mitglieder[id].

You have just reinvented mysql_fetch_assoc(), haven't you?

That would be mssql_fetch_assoc() for mssql :)

Reimplementing your code using this function would look like so:

while($data = mssql_fetch_assoc($rsResult))
{
$mitglieder[$i] = $data;
$i++;
}

and the net result is the same as your original code but quite a lot
cleaner, and using less resources.

--
Chris Hope
The Electric Toolbox - http://www.electrictoolbox.com/