It is interesting to me, how can be faster storing files on disk
versus database. If I have many pictures in database overall
db performance is slower?
Blob access tends to be less effecient due to
buffering and data transfer issues; huge tables
with images require more space and tend to be
On Wed, 13 Apr 2005 20:06:44 +1000, Ron Savage wrote:
Well, I thought I'd better put my keyboard where my mouth is, so I wrote an
article on this:
http://savage.net.au/Ron/html/images-in-files.html
I've thought of another aspect which you didn't address in that article,
and which can be very
On Mon, 25 Apr 2005 13:07:16 +0100, Jacqui Caren(IG) wrote:
Hi Folks
I've thought of another aspect which you didn't address in that
article, and which can be very important. It is how you access
the images.
Another side issue is this is mem per $sth handle issue for
mysql/oracle/et.al.
On Mon, 18 Apr 2005 10:47:05 -0400, Ivor Williams wrote:
Hi Ivor
This is relevant, but tangential to something I am doing.
see http://perlmonks.org/?node_id=448191
In particular, the idea of how we mark up an image in POD is
pertinent, and has a bearing on how one specifies an image viz
-Original Message-
From: Ron Savage [mailto:[EMAIL PROTECTED]
Sent: 13 April 2005 11:07
To: Perl - DBI users
Subject: Re: db or file access?
* Replies will be sent through Spamex to [EMAIL PROTECTED]
* For additional info click - http://www.spamex.com/i/?v=3D6273067
On Tue
On Tue, 12 Apr 2005 10:46:06 +0200, Christian Merz wrote:
Hi Folks
Well, I thought I'd better put my keyboard where my mouth is, so I wrote an
article on this:
http://savage.net.au/Ron/html/images-in-files.html
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 13/04/2005
On Wed, 13 Apr 2005 20:06:44 +1000, Ron Savage wrote:
Well, I thought I'd better put my keyboard where my mouth is, so I wrote an
article on this:
http://savage.net.au/Ron/html/images-in-files.html
It would be nice, IMHO, if your site had some sort of blog-like
structure, so that people could
From: Bart Lateur
| It would be nice, IMHO, if your site had some sort of blog-like
| structure, so that people could comment on the site itself.
Good Idea,
|
| BTW I tend to agree with you, without actually being convinced of its
| technological superiority. BTW one can use mod_rewrite to
On Apr 13, 2005, at 4:25 AM, Gav wrote:
From: Bart Lateur
| BTW I tend to agree with you, without actually being convinced of its
| technological superiority. BTW one can use mod_rewrite to nicen up
the
| URL for images.
|
| But files inside databases tend to blow up the actual database
another point is: how do you get a consistent snapshot (i.e. for backup)? if you
store things inside and outside the database neither database backup nor
filesystem backup will achieve this. one solution would be to shut down the
database and take a cold backup of the database and the file system
Ron Savage [RS], on Sunday, April 10, 2005 at 10:23 (+1000) made these
points:
RS IMHO data goes in databases and files go in directories.
RS Raving about speed is simply premature optimization, and hence is a design
fault.
ok, thanks, will store that into files, I will know in future. Is
there
On 2005-04-10 10:23:38 +1000, Ron Savage wrote:
IMHO data goes in databases and files go in directories.
Isn't that a bit a circular definition? If you store an image in a file,
it's a file and goes in a directory. If you store it in a database, it's
data.
Raving about speed is simply
Peter J. Holzer [PJH], on Monday, April 11, 2005 at 09:56 (+0200)
wrote:
PJH Consistency: Do you need to ensure consistency between this data and
PJH other data? If you store data in files, then somebody can remove or
PJH alter the files without updating the meta-data in the database.
yes, I
On Mon, 11 Apr 2005 08:58:20 +0200, Ing. Branislav Gerzo wrote:
Hi
ok, thanks, will store that into files, I will know in future. Is
there any web page about storing images in db vs. files ?
I don't know of any particular articles discussing this, but I've seen the
issues raised a number of
On Mon, 11 Apr 2005 09:56:21 +0200, Peter J. Holzer wrote:
Hi Peter
On 2005-04-10 10:23:38 +1000, Ron Savage wrote:
IMHO data goes in databases and files go in directories.
Isn't that a bit a circular definition? If you store an image in a
file, it's a file and goes in a directory. If you
Ron Savage [RS], on Monday, April 11, 2005 at 21:06 (+1000)
thoughtfully wrote the following:
RS Also, I'm glad you did not take my comments as criticism of yourself. I did
not
RS use the word 'you' which would have implied you personally were raving.
that's ok. I'd like to know both sides of
Sample database code supplied with Sybase stores pics :p
I'm sure someone somewhere will store them in databases.
--
--
Your Friendly Neighborhood DBA,
Chuck
On Apr 11, 2005 12:56 AM, Peter J. Holzer [EMAIL PROTECTED] wrote:
On 2005-04-10 10:23:38 +1000, Ron Savage wrote:
IMHO data goes in databases and files go in directories.
[--- good stuff snipped ---]
RDBMs are generally optimized for lots of small data items which are
organized into
On Sun, 10 Apr 2005 00:47:02 +0200, Ing.Branislav Gerzo wrote:
Hi
IMHO data goes in databases and files go in directories.
Raving about speed is simply premature optimization, and hence is a design
fault.
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 10/04/2005
http://savage.net.au/index.html
19 matches
Mail list logo