Mailing list
mysql@lists.mysql.com
Sent: Tue, 23 February, 2010 3:53:38 AM
Subject: RE: how things get messed up
I thought I had replied publicly to Johan’s suggestion, with
some personal experience.
He’s absolutely right, that would give you a solution that would
be completely transparent to your
, 2010 11:17 PM
To: Jerry Schwartz
Cc: Johan De Meersman
Subject: Re: how things get messed up
Dear Sir,
I agree with the solution proposed.
But one of the member[Johan De Meersman vegiv...@tuxera.be] of this list has
commented it.
Do you have any opposition/Suggestions?
Thank you
VIKRAM
We have applications for colleges in India. The same idea of having single
table for manipulating students records. but we are not following archiving
concept.
Ex stupersonal. and stuclass these tables are playing wide role in our
application. After 7 years now there are 9000
From: Vikram A [mailto:vikkiatb...@yahoo.in]
Sent: Wednesday, February 17, 2010 11:41 PM
To: Jerry Schwartz
Cc: MY SQL Mailing list
Subject: Re: how things get messed up
Dear Jerry Schwartz
We have applications for colleges in India. The same idea of having single
table for manipulating
*cough*partitioning*cough*
On Thu, Feb 18, 2010 at 5:24 PM, Jerry Schwartz
jschwa...@the-infoshop.comwrote:
From: Vikram A [mailto:vikkiatb...@yahoo.in]
Sent: Wednesday, February 17, 2010 11:41 PM
To: Jerry Schwartz
Cc: MY SQL Mailing list
Subject: Re: how things get messed up
Dear
la manipulation, nous ne pouvons accepter aucune
responsabilité pour le contenu fourni.
From: jschwa...@the-infoshop.com
To: vikkiatb...@yahoo.in; vegiv...@tuxera.be
CC: mysql@lists.mysql.com
Subject: RE: how things get messed up
Date: Tue, 16 Feb 2010 11:02:22 -0500
...@tuxera.be
Cc: MY SQL Mailing list mysql@lists.mysql.com
Sent: Tue, 16 February, 2010 9:32:22 PM
Subject: RE: how things get messed up
-Original Message-
From: Vikram A [mailto:vikkiatb...@yahoo.in]
Sent: Friday, February 12, 2010 4:13 AM
To: Johan De Meersman
Cc: MY SQL Mailing list
Subject: Re
On Mon, Feb 15, 2010 at 10:53 AM, Martijn Tonies m.ton...@upscene.comwrote:
databases are made for storing data - it saves you on both database and PHP
requests, as (from a web point of view) you can't return the image data
inside your HTML - it requires a second HTTP call. Filesystem image
On Mon, Feb 15, 2010 at 6:11 PM, Ann W. Harrison a...@mysql.com wrote:
And here's a comment from a very experienced MySQL DBA
http://sheeri.com/archives/39
Not so much a comment as her starting up the same discussion we're having
:-)
If you have the kind of needs where replicating NFS
-Original Message-
From: Ann W. Harrison [mailto:a...@mysql.com]
Sent: Monday, February 15, 2010 12:12 PM
To: Martijn Tonies
Cc: mysql@lists.mysql.com
Subject: Re: how things get messed up
There are lots of ways to screw up storage.
[JS] As the one who started this topic, I can't agree
-Original Message-
From: Vikram A [mailto:vikkiatb...@yahoo.in]
Sent: Friday, February 12, 2010 4:13 AM
To: Johan De Meersman
Cc: MY SQL Mailing list
Subject: Re: how things get messed up
Sir,
Thanks for your suggestion,
I will go for blob storage, because our application will maintain
...@the-infoshop.com
To: vikkiatb...@yahoo.in; vegiv...@tuxera.be
CC: mysql@lists.mysql.com
Subject: RE: how things get messed up
Date: Tue, 16 Feb 2010 11:02:22 -0500
-Original Message-
From: Vikram A [mailto:vikkiatb...@yahoo.in]
Sent: Friday, February 12, 2010 4:13 AM
To: Johan
plug
Just like to mention that http://www.blobstreaming.org was created to
solve this problem in MySQL.
The Launchpad project is here: https://launchpad.net/pbxt
/plug
On Feb 16, 2010, at 3:23 PM, Johan De Meersman wrote:
On Mon, Feb 15, 2010 at 10:53 AM, Martijn Tonies
Sounds logical, what's also nice to see, is that even though people here
tend to say don't put binaries in the database, apparently Facebook
thought it would be nice to do so (for all sorts of reasons) and even
took
the time to write their own blob storage mechanism ;-)
The whole point is
I am in the situation to storing student and staff images. every year
2000
new photos has to be added in our application.
Can i have your suggestion, which is the best one, storing as a blob Or
using NFS?
It will be great help to me, because such experts are sharing your own
experience on
Hi Ann,
From: Ann W. Harrison
Martijn Tonies wrote:
For example, the Firebird DBMS stores (longer) Blob data not right
there in the record, so whenever you don't request the blob (that is,
not selecting it), it ignores it completely and it can go through the
file
quickly.
As do most of
Martijn Tonies wrote:
For example, the Firebird DBMS stores (longer) Blob data not right
there in the record, so whenever you don't request the blob (that is,
not selecting it), it ignores it completely and it can go through the
file quickly.
As do most of the MySQL storage engines.
on this binary storage issue.
Thank you.
VIKRAM A
From: Johan De Meersman vegiv...@tuxera.be
To: Martijn Tonies m.ton...@upscene.com
Cc: mysql@lists.mysql.com
Sent: Fri, 12 February, 2010 1:09:32 PM
Subject: Re: how things get messed up
On Fri, Feb 12, 2010
On Fri, Feb 12, 2010 at 9:19 AM, Vikram A vikkiatb...@yahoo.in wrote:
I am in the situation to storing student and staff images. every year 2000
new photos has to be added in our application.
Can i have your suggestion, which is the best one, storing as a blob Or
using NFS?
It will be great
A
From: Johan De Meersman vegiv...@tuxera.be
To: Vikram A vikkiatb...@yahoo.in
Cc: MY SQL Mailing list mysql@lists.mysql.com
Sent: Fri, 12 February, 2010 2:23:01 PM
Subject: Re: how things get messed up
On Fri, Feb 12, 2010 at 9:19 AM, Vikram A vikkiatb...@yahoo.in wrote:
I am in the situation
Martijn Tonies wrote:
For example, the Firebird DBMS stores (longer) Blob data not right
there in the record, so whenever you don't request the blob (that is,
not selecting it), it ignores it completely and it can go through the file
quickly.
As do most of the MySQL storage engines.
Cheers,
Hello John,
About 5 years ago, I was asked to write a php app for my department. The
app keeps track of graduate school applicants to my department at the
university. The main data elements are the scores each professor gives to
each applicant. There are only about 400 applicants each year so
On Thu, Feb 11, 2010 at 8:56 AM, Martijn Tonies m.ton...@upscene.comwrote:
Hello John,
About 5 years ago, I was asked to write a php app for my department. The
app keeps track of graduate school applicants to my department at the
university. The main data elements are the scores each
-Original Message-
From: Cui Shijun [mailto:rancp...@gmail.com]
Sent: Wednesday, February 10, 2010 10:53 PM
To: Ilya Kazakevich
Cc: John G. Heim; mysql@lists.mysql.com
Subject: Re: how things get messed up
Hello Ilya,
I think store files in DB has no complicated reasons, just
-Original Message-
From: John G. Heim [mailto:jh...@math.wisc.edu]
Sent: Wednesday, February 10, 2010 2:09 PM
To: mysql@lists.mysql.com
Subject: how things get messed up
It is amazing how often quick dirty turns out just being
dirty in the end.
[JS] Hee-hee... How right you are. I've
Hi Ilya, everybody!
Ilya Kazakevich wrote:
[[...]]
IMHO:
Storing files in DB is probably bad idea.
Here are some advantages of storing files on filesystem:
[[...]]
We could discuss them individually, but I agree several of your points
are valid. The remaining question is which importance
On 2/10/10, Ilya Kazakevich wrote:
There was a joke in russian PHP club: why strore images in database? Are
you going to have a full text search on them?
Yes. That is what EXIF data is for, isn't it?
And considering this is about PDFs any inability of a database engine
to do a full text search
I think store files in DB has no complicated reasons, just for
convenience. For example, I might make files automatically be
backup-ed, and no budget for an independent backup solution. Thanks.
Cui
[JS] Storing BLOBs in a table must slow down the inner workings of the
database engine. After
[JS] Storing BLOBs in a table must slow down the inner workings of the
database engine. After all, the tables are really disk files under the
covers.
Can the database engine read only parts of a file record?
Jerry Schwartz
Well, there's where things go wrong -- first of all, a database
On Thu, Feb 11, 2010 at 5:24 PM, Jerry Schwartz
jschwa...@the-infoshop.comwrote:
[JS] Storing BLOBs in a table must slow down the inner workings of the
database engine. After all, the tables are really disk files under the
covers.
Can the database engine read only parts of a file record?
[JS] Storing BLOBs in a table must slow down the inner workings of the
database engine. After all, the tables are really disk files under the
covers.
Can the database engine read only parts of a file record?
Jerry Schwartz
Well, there's where things go wrong -- first of all, a database
On Fri, Feb 12, 2010 at 8:05 AM, Martijn Tonies m.ton...@upscene.comwrote:
Firebird uses 1 or multiple files per database, not per table, this file
has
a special blob area, so to speak, and the records include a blob ID.
When a client/stored routine selects a blob that isn't available in the
On Fri, Feb 12, 2010 at 8:27 AM, Martijn Tonies m.ton...@upscene.comwrote:
Sounds logical, what's also nice to see, is that even though people here
tend to say don't put binaries in the database, apparently Facebook
thought it would be nice to do so (for all sorts of reasons) and even took
About 5 years ago, I was asked to write a php app for my department. The app
keeps track of graduate school applicants to my department at the
university. The main data elements are the scores each professor gives to
each applicant. There are only about 400 applicants each year so even with
John G. Heim wrote:
About 5 years ago,...
then the selection committee asked me to add something ...
Then the next year, the graduate school changed their ...
Then they started taking letters of recommendation ...
One might think of this as scope-creep, but really, given the
length of time
.
If somebody knows more reasons to store files in DB -- post it here, please.
It would be interesting. Thanks.
Ilya.
-Original Message-
From: John G. Heim [mailto:jh...@math.wisc.edu]
Sent: Wednesday, February 10, 2010 10:09 PM
To: mysql@lists.mysql.com
Subject: how things get messed up
About 5
knows more reasons to store files in DB -- post it here, please.
It would be interesting. Thanks.
Ilya.
-Original Message-
From: John G. Heim [mailto:jh...@math.wisc.edu]
Sent: Wednesday, February 10, 2010 10:09 PM
To: mysql@lists.mysql.com
Subject: how things get messed up
About 5
37 matches
Mail list logo
