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.
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
images take a bit (really short but absolutly noticable) to
11 matches
Mail list logo
