Notes
Some implementation notes:
-
Support was added for
MYSQL_TYPE_GEOMETRY
to the MySQLi extension in PHP 5.3. -
Note there are different internal implementations within
libmysqlclient
andmysqlnd
for handling columns of typeMYSQL_TYPE_GEOMETRY
. Generally speaking,mysqlnd
will allocate significantly less memory. For example, if there is aPOINT
column in a result set,libmysqlclient
may pre-allocate up to 4GB of RAM although less than 50 bytes are needed for holding aPOINT
column in memory. Memory allocation is much lower, less than 50 bytes, if usingmysqlnd
.