Does the mysql_query function already fetch the data ?

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello,
>
> the documentation says:
> The returned result resource should be passed to mysql_fetch_array(), and other
> functions for dealing with result tables, to access the returned data.
>
> Does this mean that all the data is already fetched from the DB and loaded into
> RAM and I only need the mysql_fetch_* functions to extract it ?
>
> eg.
>
> $query = mysql_query("SELECT * FROM `table`");
>
> If in table are rows worth some megaBytes, are those megabytes already loaded
> into RAM or is this only happening if if I use mysql_fetch_assoc/array etc.
>
> eg.
>
> $query = mysql_query("SELECT * FROM `table`");
> // is the data already here loaded into RAM
> while($result = mysql_fetch_assoc($query)) {
> $newArray[] = $result;
> // or at this point ?
> }
>
>
> regards,
> johannes keßler
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.14 (GNU/Linux)
>
> iEYEARECAAYFAktwKHUACgkQE++2Zdc7Etd1PwCfcJttayTQuImXhipHk5ocdY2M
> VdMAn2nZJIyCaThw+zXDRYBaDqx7wJCR
> =b1CY
> -----END PGP SIGNATURE-----

> Hello,
> the documentation says:
> The returned result resource should be passed to mysql_fetch_array(), and other
> functions for dealing with result tables, to access the returned data.
> Does this mean that all the data is already fetched from the DB and loaded into
> RAM and I only need the mysql_fetch_* functions to extract it ?
> eg.
> $query = mysql_query("SELECT * FROM `table`");
> If in table are rows worth some megaBytes, are those megabytes already loaded
> into RAM or is this only happening if if I use mysql_fetch_assoc/array etc.
> eg.
> $query = mysql_query("SELECT * FROM `table`");
> // is the data already here loaded into RAM
> while($result = mysql_fetch_assoc($query)) {
> $newArray[] = $result;
> // or at this point ?
> }

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> Hello,
> the documentation says:
> The returned result resource should be passed to mysql_fetch_array(), and=

> functions for dealing with result tables, to access the returned data.
> Does this mean that all the data is already fetched from the DB and loade=

> RAM and I only need the mysql_fetch_* functions to extract it ?
> eg.
> $query =3D mysql_query("SELECT * FROM `table`");
> If in table are rows worth some megaBytes, are those megabytes already lo=

> into RAM or is this only happening if if I use mysql_fetch_assoc/array et=

> eg.
> $query =3D mysql_query("SELECT * FROM `table`");
> // is the data already here loaded into RAM
> while($result =3D mysql_fetch_assoc($query)) {
> =A0 =A0$newArray[] =3D $result;
> =A0 =A0// or at this point ?
> }
> regards,
> johannes ke=DFler

> wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> > Hello,
> > the documentation says:
> > The returned result resource should be passed to mysql_fetch_array(), a=

> > functions for dealing with result tables, to access the returned data.
> > Does this mean that all the data is already fetched from the DB and loa=

> > RAM and I only need the mysql_fetch_* functions to extract it ?
> > eg.
> > $query =3D mysql_query("SELECT * FROM `table`");
> > If in table are rows worth some megaBytes, are those megabytes already =

> > into RAM or is this only happening if if I use mysql_fetch_assoc/array =

> > eg.
> > $query =3D mysql_query("SELECT * FROM `table`");
> > // is the data already here loaded into RAM
> > while($result =3D mysql_fetch_assoc($query)) {
> > =A0 =A0$newArray[] =3D $result;
> > =A0 =A0// or at this point ?
> > }
> > regards,
> > johannes ke=DFler
> You could always run some tests with memory_get_usage()