Re: File Fun

D,

Are there pros or cons that I've missed? Has anyone actually TRIED it?
I've read about a 47kb limit problem that some people have. Anyone know
anything about this?

Actually I am running a system where I store 3 different images in a row. One large sizes, one medium sized, and one thumbnail.

Mine is a bit different. I cache all the queries and all pages on the harddrive anyways. So therefore they are still in the database but get pulled from a cache 98% of the time.

However with this technique I have found that it has been almost exactly the same if not a bit faster than my previously tried routines.

When you read about it I think it all comes down to personal preference. There are several ways to do it and advantages to both. I decided to basically mix the two and have the full advantage :)

I also store files in the database as well, some disagree with this just like images, but for the most part when they see the app they can't even tell the difference. Most people are talking technically about what should and shouldn't be done and why it would be bad. And just adopt it when they hear it 400 times. Never hurts to try something once and merge it to something else (just use oop so you can expand the original class)

Mike
.

Relevant Pages

  • Re: LDAP Performance (long)
    ... Cache the slapd's internal database lookups in slapd memory. ... The first is the new TAG:key lookup, ...
    (comp.mail.sendmail)
  • Re: Cache-Size vs Performance
    ... logarithmic decrese in the miss rate as the cache size grows ... in big database applications ... ... where the database uses real storage to compensate for disk record ... database people in stl/bldg90 and the relational/sql system/r people ...
    (comp.arch)
  • Re: Running queries on large data structure
    ... ugly to convert it into some relational shape for the database) ... of time when reloading them from disk but YMMV and you would have to ... pickle it and load it later and work on the data? ... My data layer checks the cache ...
    (comp.lang.python)
  • Re: ASP.Net Caching Questions
    ... As stated, the lookups have to be as fast as possible, so the idea is ... Loading the information from a file or sql column will not ... database will perform comparably to using Cache. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How to set up Filemaker to avoid decreasing of speed
    ... it should be not that lenghly in processing time. ... I don't know if to change drastically the cache memory size would ... > revenue is criteria for each of 10% of subscribers. ... > where each record at master database responds as: ...
    (comp.databases.filemaker)