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 for
-Original Message-
From: MuraliKrishna [mailto:murali_kris...@arthaoptions.com]
Sent: Thursday, February 11, 2010 12:52 AM
To: mysql@lists.mysql.com
Subject: help me out for this scenario
I have a table like as follws
Emp_id, first_login , second_login
[JS] I think you are asking for
-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
Could any one lead me to a true link where I can download the world.sql sample
database? Thanks.
On 2/11/2010 11:47 AM, kebede teferi wrote:
Could any one lead me to a true link where I can download the world.sql sample
database? Thanks.
http://dev.mysql.com/doc/index-other.html
Carlos Proal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
On Feb 11, 2010, at 11:47 AM, kebede teferi wrote:
Could any one lead me to a true link where I can download the world.sql
sample database? Thanks.
Go to:
http://dev.mysql.com/doc/
Click on the Other Docs tab to get to:
http://dev.mysql.com/doc/index-other.html
You'll see an entry for
Andy,
On Tue, Feb 9, 2010 at 10:27 AM, andy knasinski a...@nrgsoft.com wrote:
I've used the general and slow query log in the past, but I am trying to
track down some queries from a compiled app that never seem to be hitting
the DB server.
My guess is that the SQL syntax is bad and never get
[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
17 matches
Mail list logo
