Re: In need of advise about saving large binary data

mebe wrote:
i am working on a project where users are able to submit any ammount
of large binary files.
Currently all data is stored in a MySql database, but i am uncertain
if it would be better/more efficient/faster to store the binary files
on the filesystem. This would certainly save MySql from a lot of work,
but ensuring data integrity could become complicated.
I am uncertain if it is a good idea to move the binary data out of the
database, so i appreciate any information.
Thanks in advance.

If it is huge files I would suggest using the file system
(unless you have database software and a real powerhouse of a database
server to handle it - think Oracle or DB2 on p595 or similar).

But for smaller files (let us say below 2 MB to pick an arbitrary
size) on decent hardware (not your old 486), then I would find using
the database attractive.

Performance will be approx. the same, but it will be much
easier to manage both app wise and operational.

Arne
.

Relevant Pages

  • getting data from a shopping cart mysql database
    ... In short - What is a good way to do daily updates from a webstore's ... mysql database into an Access database? ... what we would like to do is "connect" to the mysql database ... but the store will be using a new off-the-shelf shopping ...
    (microsoft.public.access.externaldata)
  • Re: Put Variables giving problems
    ... And - I would actually prefer to get it into a database that Access2000 ... >> phone as string ... > will be written to a Random file as a set of variable-size elements, ... > function for Random or Binary files. ...
    (microsoft.public.vb.syntax)
  • Re: serialized binary files vs Sql Server Performance..
    ... i'm developing for a high traffic webisite, and i would like to query this DB to get the City info from the DB when a visitor first visits the site. ... how do serialized binary files handle simultaneous file access? ... A database can handle that much data easily. ... Perhaps the best thing to do would be to benchmark both and to do some load testing. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Help reading structured binary files
    ... into our database. ... This is really the first time I've ... messed with binary files like this and I'm sure I'm doing it all wrong. ... byte into its CHR value for a string? ...
    (comp.lang.pascal.delphi.misc)
  • Re: Back-to-front introduction needed
    ... Dim myTable As New DataTable ... Use WriteXml/ReadXMl to read/write the dataset to/from disk... ... > stored eg in non-database binary files that need to be presented in ... > any database program will be present on their PCs. ...
    (microsoft.public.dotnet.framework.adonet)