Databases Reference
In-Depth Information
Evaluating the impact of memory limits
On some servers, the default value in
php.ini
for
memory_limit
is
8M
, meaning
8 MiB. This is too low for correct image manipulation, because the GD functions
used to produce the final images need working memory. For example, in one test, a
value of
11M
in
memory_limit
was needed to generate the thumbnail from a 300 KiB
JPEG image. Also, if multiple rows are viewed at once, more working memory will
be needed.
Examples of transformations
We will now discuss a few transformation examples. Typical option values are shown,
and it's recommended to tweak them until we have achieved the desired results.
Depending on the phpMyAdmin version, more transformations may be available.
Clickable thumbnail (JPEG or PNG)
We will start by changing our
cover_photo
column type from
BLOB
to
LONGBLOB
to ensure that we can upload photographs bigger than 65 KiB in size. We then enter
the attributes shown in the following screenshot:
Search WWH ::
Custom Search