Personally, I would have to disagree. I have just completed a year-long
uni project whereby we built some software that stored massive images in
InnoDB tables. We found that the performance was (at very worst)
comparable to the alternative method.
Additionally, this method is better on many
Chris Nolan wrote:
Personally, I would have to disagree. I have just completed a
year-long
uni project whereby we built some software that stored massive images
in InnoDB tables. We found that the performance was (at very worst)
comparable to the alternative method.
Additionally, this
you could very well do that, and frankly that is how alot of websites
work.
Yep, including one I run. That site has to generate img and a href links
for visitors, and it seems far easier to return /pics/imagefoo.jpg then
the image itself and decide how to embed that into the page.
But
Really? In both cases, it's just bits on a disk. In the case where you
don't have access to a shared file repository for your client apps, you
haven't got the option of just storing paths.
Regards,
Chris
On Sat, 2003-12-13 at 23:30, Sime wrote:
Chris Nolan wrote:
Personally, I would have to
Talk about a decent reply!
For web site stuff, having control over everything is pretty much a
requirement (if you want to do anything non-trivial). The way that I
serve images from the database is by parsing URLs and I've found that
the performance is very good. The fact that I can move stuff
Forgot something in my other reply.
With the NAS - what's to say that MySQL's retrieval and network protocol
is not more efficient than whatever is running on your NAS boxes?
Conversely, MySQL's current 16 MB per transfer limitation may very well
not allow it to act in this role at all.
Ah, the
With the NAS - what's to say that MySQL's retrieval and
network protocol
is not more efficient than whatever is running on your NAS boxes?
Well, currently we work like so:
Client - Webserver/Application Server - Database
The database returns file names to the application/webserver (yes,
This page has sample article/code how to store any type/size of file in
mysql.. Depending on the appliation it could be a good idea (such as
revision control or something)
http://php.dreamwerx.net/forums/viewtopic.php?t=6
On Fri, 12 Dec 2003 [EMAIL PROTECTED] wrote:
I am working with a
I'd agree with chris. I've got a ton of data/files in mysql for years
now and no problems... The thruput in/out is increadible if you implement
the storage handler correctly.
Plus it gives you certain advantages such as security/scalability/etc...
With storing the files on disk, the files
16MB? you mean the max packet per query limit? If your storing data in
huge/large blob then you are making a big mistake in my opinion and taking
a huge performance hit... I've got files over 1GB in size in mysql now..
they went in and out at almost filesystem speed...
On Sun, 14 Dec
True initially... What I've done is use a java appserver frontend (orion)
that's a caching server.. It gets the request, checks if it has the image
in it's memory cache, if so serves it, otherwise goes to the backend and
gets it, stores in memory cache, serves it..
Very fast and aleviates alot
Can I ask why?
Why not define a char(50) (or whatever size) with the relative or complete
path to the .tar file? Storing it in your database would create huge row
sizes.
Joshua Thomas
Network Operations Engineer
PowerOne Media, Inc.
tel: 518-687-6143
[EMAIL PROTECTED]
---
In theory there is no
On Fri, Dec 12, 2003 at 02:54:44PM -0600, [EMAIL PROTECTED] wrote:
I am new to mysql and I was wondering if someone could point me in the
right direction on how to store .tar and .tar.gz (bzip2) files inside a
mysql database. I have googled to try and find some help there but most
I believe the
I am working with a project on sourceforge http://leopard.sourceforge.net
and this is one of the package management stratagies we are thinking about
trying. As I said I have almost no experience with mysql so I open to any
and all suggestions. Very good points being made about the size of the
On Fri, Dec 12, 2003 at 02:54:44PM -0600, [EMAIL PROTECTED] wrote:
Hi all,
I am new to mysql and I was wondering if someone could point me in the
right direction on how to store .tar and .tar.gz (bzip2) files inside a
mysql database. I have googled to try and find some help there but most
of
15 matches
Mail list logo