Am Mittwoch, 3. Juli 2002 20:43 schrieb central:
> >More specific: Can I efficiently read the bytes x to y from
> > any BLOB stored in a MySQL database?
>
> Why not just add another column, Char(3), that contains the
> file extension?
That would fix this particular case, but my thought were more
Kristian,
>Question: Can the MySQL BLOB API access and transfer partial
>blobs. That is, if you want to do the equivalent of a "file *"
>to a BLOB table, the first 10 bytes or so of each BLOB must be
>read in order to guess the type of the BLOB. Is it possible to
>implement this efficiently using
Am Mittwoch, 3. Juli 2002 10:58 schrieb Elizabeth Mattijsen:
> Not meaning to put down MySQL, but have you tried this also
> with a ReiserFS filesystem? I had a similar number of files,
> about 70 GByte worth on an ext2 filesystem. Moved them to a
> ReiserFS filesystem and found I only needed 51
Hello.
On Wed 2002-07-03 at 09:42:52 +0100, [EMAIL PROTECTED] wrote:
[...]
> I was thinking more of an application like an access control system, where
> there might be tens of thousands of photographs of people, each a jpeg of a
> small number of K, or a catalogue, again with thousands of tiny p
At 09:42 AM 7/3/02 +0100, Tim Ward wrote:
>I was thinking more of an application like an access control system, where
>there might be tens of thousands of photographs of people, each a jpeg of a
>small number of K, or a catalogue, again with thousands of tiny photos.
>
>The experiment I did with 5
> Grabbing a half-gig video segment out of any
> database
I'm sure you're absolutely right about not putting half gig videos in a
database!
I was thinking more of an application like an access control system, where
there might be tens of thousands of photographs of people, each a jpeg of a
small
> Yes, but, this advice does *not* go on to describe how you cope with the
> deletion problem.
>
> If you store data in records in the database a DELETE will delete *all* the
> data for the set of rows. If some of the data is lying around in disk files
> these obviously don't get deleted by DELET
>
> There are several reasons why you should consider not storing
> binary data in
> your database:
>
> [snip]
>
> You probably have several reasons why you would want to store
> your images in
> your database, despite all the statements above. Others have,
> before you. And
> they have all return
Op maandag 1 juli 2002 14:18, schreef andy:
> Hi there,
>
> I am wondering if anybody has experiance in saving images to blob in mysql.
>
> I do save images with 1 K and 4 KB to blob fields while I used to save them
> to file. It seams to me that this is much slower accessing the files. The
> imag
Andy,
File Systems are made to store and retrieve files in an efficient way. You
may not expect better performance when you put a database in between. When
speed is an issue you should use MySQL to store and retrieve filenames and
something like ReiserFS, RAID and good hardware to store images.
10 matches
Mail list logo
