Performance/handling limit on mysqli_real_escape_string() function?
| From: | Jacob Kruger | Date: | Mon, 12 Aug 2013 21:24:26 +0000 |
| Subject: | Performance/handling limit on mysqli_real_escape_string() function? | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-31106@lists.php.net to get a copy of this message | ||
What with trying to store image data in mySQL database, I am saving the results of fread() function
carried out using the file handle returned from fopen(), with the "rb" argument to tell it
the file is for binary reading.
Either way, for example, this specific image file is a 2.1Mb PNG file, and mySQL server on my local,
windows development machine seems to lock up roundabout when I tell it to carry out the
mysqli_real_escape_string() function on the value of the variable that now contains the data read
from the physically uploaded file, and just wondering if this could be something like a process
overload, etc., and whether should just try taking out the string real escaping for now, or whether
that's likely to cause problems, or should I try something like splitting the file's data
into more manageable size chunks, carry out the string escaping on those chunks one at a time, with
even a possible form of pause inbetween, and then re-append them together before writing them to the
database, or should I maybe just implement at least a form of file size limit, which might be an
issue if the user will insist on certain image sizes, resolutions, etc. etc.?
Thoughts/suggestions?
TIA
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'