Stut wrote:
>
> On 29 Oct 2008, at 10:32, vuthecuong wrote:
>>
>> Stut wrote:
>>>
>>> On 29 Oct 2008, at 10:20, vuthecuong wrote:
>>>> technically can I store flash file into Mysql DB using PHP?
>>>
>>> Yes.
>>>
>>>> what point should I pay attention for that?
>>>
>>> The blob field type.
>>>
>>> But I would recommend against it. Why not store the files on disk and
>>> only store the filenames in the DB?
>>>
>> Thanks for fast reply. Could you tell me the reason against it?
>
> In my experience it's a lot harder to manage than files. DB backups
> and restores start taking a long time - not good when disaster strikes
> and you need to get back up and running quickly. Scripts that serve
> blobs can take up a lot of memory since they need to load the entire
> blob before outputting it to the browser whereas files can be streamed.
>
> Google for something like store files in mysql and you'll find a lot
> of opinion on the advantages and disadvantages. If the files are small
> enough and there aren't many then it can work well, but personally I'd
> never do it again after some nasty experiences a few years back.
>
> -Stut
>
> --
> http://stut.net/
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
THanks Stut, I learned from you a lot. I'll take that into account.
regards
--
View this message in context:
http://www.nabble.com/Newbie%3A-can-I-store-flash-file-into-Mysql-DB-tp20224150p20224881.html
Sent from the PHP - General mailing list archive at Nabble.com.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
