On Fri, Feb 12, 2010 at 8:27 AM, Martijn Tonies wrote:
> 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
On Fri, Feb 12, 2010 at 8:05 AM, Martijn Tonies
wrote:
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
record
data (sto
On Fri, Feb 12, 2010 at 8:05 AM, Martijn Tonies wrote:
> 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
> 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 engi
On Thu, Feb 11, 2010 at 5:24 PM, Jerry Schwartz
wrote:
> [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?
>
They recently invented t
>> [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
Andy,
On Tue, Feb 9, 2010 at 10:27 AM, andy knasinski 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 executed, b
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 fo
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 unsubs
Could any one lead me to a true link where I can download the world.sql sample
database? Thanks.
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
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 sea
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 impor
>-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
>-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
>-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 fo
On Thu, Feb 11, 2010 at 8:56 AM, Martijn Tonies wrote:
> 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
>
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
18 matches
Mail list logo
