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
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
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
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
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
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 the
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
images
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 returned to the
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 DELETE. So
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
