Re: db or file access?
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
slower for scanning (when necessary) due to
larger record overhead (depending on whether
the blobs are stored inline).
Grabbing a relative path (or URI) from the
database as a string doesn't rquire special
buffering or conversions, leaves the table
smaller.
--
Steven Lembark 85-09 90th Street
Workhorse Computing Woodhaven, NY 11421
lembark@xxxxxxxxxxx 1 888 359 3508
.
Relevant Pages
- Re: [PHP] Re: how to display images stored in DB*
... Your claim is that in ALL cases using a file system to store images ... bitmaps in a database without a damn good reason, a bad practice, yes. ...
(php.general) - Re: [PHP] Re: how to display images stored in DB**
... for storing images is "bad" practice. ... "Bad" practice or "good" practice depends upon the needs and one's perspective of the situation. ... If you were to talk to the average computer user; or to the average investor who invests in technologies; or to the businessman who is paying the bills for programmers to build the product while trying to make money at the same time; they all might have different opinions as to the quality and state of software. ... If you assume that you have one database supply all the images to all ...
(php.general) - Re: bound object frame: picture
... Please let me respond to your critique and hopefully help Bob along the way. ... generates can be very large when they contain images. ... Print event NOT THE FORMAT EVENT. ... your entire database will stop working when you get about 100 pictures ...
(microsoft.public.access.forms) - Re: DABsworth in disguise?
... time, as suffering from buffering. ... problematic IP address prefixes would account for the vast majority ... The BBC has the Quova Geo-location database at its disposal, ... yesterday about analyzing a few months' worth of log files wouldn't ...
(alt.radio.digital) - Re: ListView - Caching Thumbnails?
... The program just will yield some odd results if they do (which I figure they can deal with if they are monkeying with the database;). ... Access databases fill the middle ground I guess but still, you can edit XML by hand. ... The underlying goal here is to create an interactive anatomical atlas program using high resolution images. ... Then I go back to school ). ...
(microsoft.public.dotnet.languages.vb) |
|
