This one time, at band camp, [EMAIL PROTECTED] wrote:
I don't feel the implementation direction this article takes is good. It
uses single row binary storage, which anyone who has had to deal with
large files knows is a definate issue.
According to your method of storing binary data in
I would love to see an implementation with 1 row for large data that works
well. The main issues I had were that mysql has a default max packet size
limit (I think it used to be like 16MB (mysql 3.23) - 1GB Mysql 4 - Not
sure v5. Alot of people don't have control over those settings in their
I don't feel the implementation direction this article takes is good. It
uses single row binary storage, which anyone who has had to deal with
large files knows is a definate issue.
On Sat, 21 Apr 2007, Kevin Waterson wrote:
This one time, at band camp, Michael Higgins [EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
I don't feel the implementation direction this article takes
is good. It uses single row binary storage, which anyone who
has had to deal with large files knows is a definate issue.
Just wanted to thank
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Friday, April 20, 2007 3:16 PM
To: Michael Higgins
Cc: mysql@lists.mysql.com
Subject: Re: advice for blob tables?
At any rate - based on my experience with the Sybase system I managed, I
would advise you
Hi Michael,
You are not the only one with this problem. We work in the print/
publishing sector and have many customers that need this type of
functionality as well.
So this is not going to help you right away, but we have consulted
with MySQL and are starting an initiative for the
Michael, here's what I can tell you -
Some people will advise you against storing documents in tables - claim it
makes the data harder to serve up, etc. I agree it's quite simple to set up
a folder structure with your files on the filesystem and point Apache or IIS
to it while tracking metadata
Here's a good php implementation, you can implement the concept in any
language you like:
http://www.dreamwerx.net/phpforum/?id=1
On Fri, 20 Apr 2007, Michael Higgins wrote:
Hello, all --
I want to set up a database for document storage. I've never worked with
binary files stored in
This one time, at band camp, Michael Higgins [EMAIL PROTECTED] wrote:
So before I just jump in and go like I usually do, does anyone have any
quick advice, things to consider, links, must-RTFMs or the like to help a
newbie out?
This tutorial deals with images and BLOBs. It should get you
Here is my suggestion, but like every other thing I post here I urge you to
take it with a grain of salt. Set up the following tables (described in
rough terms, not in SQL):
topic_index
topic_id autonumber
... Whatever else you need to keep track of that identifies a topic
What are specifications of your DB. How much of data you have. How mant
transactions you will be getting daily.
Without these details it will be difficult to answer ur question.
But for a centralised database server, I guess 1G RAM and 2CPU will be a
good configuration to start with.
sujay
Vinayak Mahadevan [EMAIL PROTECTED] wrote on 27/09/2005 04:55:13:
I am creating an application in Visual Basic 6.0 which will require a
centralised database server. All this while I had been planning to use
MS-Access. But then I found out that MS-Access is ok to be a desktop
rdbms but not
[EMAIL PROTECTED] wrote:
Vinayak Mahadevan [EMAIL PROTECTED] wrote on 27/09/2005 04:55:13:
I am creating an application in Visual Basic 6.0 which will require a
centralised database server. All this while I had been planning to use
MS-Access. But then I found out that MS-Access is ok to
Vinayak Mahadevan [EMAIL PROTECTED] wrote on 27/09/2005 11:28:51:
[EMAIL PROTECTED] wrote:
Vinayak Mahadevan [EMAIL PROTECTED] wrote on 27/09/2005 04:55:13:
I am creating an application in Visual Basic 6.0 which will require a
centralised database server. All this while I had been
At 15:53 +1000 on 06/07/2004, Ligaya Turmelle wrote about Re: Advice
on Database Schema Design:
I think I get what you are trying to do and it sounds good (though I am
still a beginner). The only thing I can think that might cause a problem is
since you have more then a couple of tables you MAY
I think I get what you are trying to do and it sounds good (though I am
still a beginner). The only thing I can think that might cause a problem is
since you have more then a couple of tables you MAY have to write joins for
all of them . Only you would know if you can do that and/or be
David Blomstrom wrote:
I put a screenshot of my database organization online
at
http://www.geoworld.org/database.gif It features four
tables, focusing on Continents, Nations, States and
Counties. Notice that Continents and Nations share a
CCode (continent codes) column
So how are you going to put
]
Subject: Re: Advice on Database Scheme
David Blomstrom wrote:
I put a screenshot of my database organization online at
http://www.geoworld.org/database.gif It features four tables, focusing
on Continents, Nations, States and Counties. Notice that Continents
and Nations share a CCode (continent
--- Jochem van Dieten [EMAIL PROTECTED] wrote:
David Blomstrom wrote:
--- Jochem van Dieten [EMAIL PROTECTED]
wrote:
So how are you going to put Russia in both Asia
and
Europe? How are you going to put Turkey in both
Asia
and Europe? Egypt in Africa and Asia?
Egypt is in
Hi Alexander,
Perhaps the console application would be better suited for you. That
way the response is always ASCII text, and you only need to type the
commands.
In case you haven't tried the console before ...
To start the console application: 1. Open a DOS prompt (in windows) or a
command
-Forwarded by Peter J Milanese/MHT/Nypl on 01/20/2004 02:36PM -
To: STE-MARIE, ERIC [EMAIL PROTECTED]
From: Peter J Milanese/MHT/Nypl
Date: 01/20/2004 02:31PM
cc: [EMAIL PROTECTED]
Subject: Re: Advice needed for high volume of inserts
It'll work.
I do slight less on the way
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On January 20, 2004 02:31 pm, Peter J Milanese wrote:
It'll work.
I do slight less on the way of inserts. What I do is dynamically generate
the tables within my entry code, and merge tables based on the query. Good
for large log parsers. Be
PROTECTED]
From: STE-MARIE, ERIC [EMAIL PROTECTED]
Date: 01/20/2004 02:41PM
cc: [EMAIL PROTECTED]
Subject: Re: Advice needed for high volume of inserts
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On January 20, 2004 02:31 pm, Peter J Milanese wrote:
It'll work.
I do slight less on the way
-Original Message-
From: Donald Tyler [mailto:[EMAIL PROTECTED]
Sent: 30 July 2003 16:42
To: [EMAIL PROTECTED]
Subject: Advice wanted on Data Structure
I have a question that I hope I can explain well enough:
I am trying to figure out a data structure for an inventory
system.
I try a solution like this. It's kind of a tree [so your warned that this
structure will be a waste of time if you have a subkit to a subkit to a... ]
KITS
kt_id int
kt_things.
parent_kt_id_fk int
constraint fk_KITS foreign key (parent_kt_id_fk) references kits(kt_id)
For details consult
Donald,
I've done this before - it wasn't nice. The best solution I came up with
was to store the kits in the item table as though they were items. So
the structure is: (Lets call a 'Product' an Item or a Kit depending on
the 'prod_type')
PRODUCT KIT CONTENTSPRODUCT
Hi,
I'm not to familiar with MySQL, but as far as I can seem, you might want to
look at programming.
I.e a program in C++ or Perl, or Visual Basic.
Anthony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
On 01-Jun-2003 Daniel Crompton wrote:
snip
If for example we move song number 5 up to number 1, we then have to
manually change the
' Chart Number' of all the ones below it, i.e. changing the old number
1 to a number 2,
number 2 to a number 3, number 4 to a number 5 etc.
Ideally we
SET @rank:=5;
UPDATE music SET chart=0 WHERE [EMAIL PROTECTED];
UPDATE music SET chart=chart+1 WHERE chart@rank;
Thanks Don
Unfortunately though i think we need to be able to make the changes in
something we can see which is why we are using mysqlcc.
With mysqlcc any of us can simply
OK, here's a lengthy answer:
I don't use MySQLCC, so I'm assuming that it has a way that you can
enter and run SQL statements.
Say our top 10 songs are:
mysql [test] SELECT * FROM musicchart ORDER BY chartnumber LIMIT 10;
+-+--++
let the DB manage the sequencing before and after Make Chart # an Index
Martin
- Original Message -
From: Don Read [EMAIL PROTECTED]
To: Daniel Crompton [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, June 01, 2003 1:54 PM
Subject: RE: Advice on improving our current method
On 01
# an Index
Martin
- Original Message -
From: Don Read [EMAIL PROTECTED]
To: Daniel Crompton [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, June 01, 2003 1:54 PM
Subject: RE: Advice on improving our current method
On 01-Jun-2003 Daniel Crompton wrote:
snip
If for example
www.becomingdigital.com
- Original Message -
From: Daniel Crompton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, 01 June, 2003 14:00
Subject: Re: Advice on improving our current method
SET @rank:=5;
UPDATE music SET chart=0 WHERE [EMAIL PROTECTED];
UPDATE music SET chart=chart+1 WHERE
Hi George,
I am about to start the planning process in moving my FileMaker/Lasso/PHP
site over to MySQL/PHP.
Before I get too far down the road, should I be using InnoDB or MyISAM
tables? The service is initially going to be hosted on WinNT but may move
over to Linux later.
=main response,
From: George Pitcher [EMAIL PROTECTED]
I am about to start the planning process in moving my FileMaker/Lasso/PHP
site over to MySQL/PHP.
Before I get too far down the road, should I be using InnoDB or MyISAM
tables?
InnoDB does not support FULLTEXT indeces. Since FileMaker searches are always
João Borsoi wrote:
I working in a project to be released 6 months from now. We are
currently using mysql 3.23.49 with Innodb. I'm thinking about upgrading
it to mysql 4.0.5a because of some deadlock bugs. What is the risk of
going to a development version? Is it stable?
I've been living on
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Joao --
...and then João Borsoi said...
%
% I working in a project to be released 6 months from now. We are
% currently using mysql 3.23.49 with Innodb. I'm thinking about upgrading
% it to mysql 4.0.5a because of some deadlock bugs. What is the
* Hayan Al Mamoun
I have two design-identical database, one on my intranet, the other on
the internet, is there any procedure that Synchronizes the content of
two databases?
Depends on what you mean with 'Synchronizes'.
'Real' synchronization, where both servers are written to and both must
Tod Harter writes:
Hi Guys
I've been using MySQL for a few years now, but always on medium sized
projects. I think the biggest thing I ever did has maybe 200k records in it.
Now all of a sudden I have a client with a requirement for a database that we
estimate will be in the range of
On Tuesday 29 January 2002 12:40, Sinisa Milivojevic wrote:
Tod Harter writes:
Hi Guys
I've been using MySQL for a few years now, but always on medium sized
projects. I think the biggest thing I ever did has maybe 200k records in
it.
Now all of a sudden I have a client with a
Tod Harter writes:
What would be the performance considerations? Considering it theoretically if
I (for instance) set things up so that I had an ftp server for the images and
stored filenames in a column then as far as raw data transfer efficiency its
tcp either way. I guess the question
*] I need to generate a RANDOM UNIQUE number for every new record. Is
there an
*] easy way to accomplish this inside of mySQL.
*]
What are the requirements for 'random' and 'unique'? Do you need some sort
of cryptographic randomness? Does uniqueness be kept across tables?
If you 'only'
On Thu, 24 May 2001, Aigars Grins wrote:
*] I need to generate a RANDOM UNIQUE number for every new record. Is
there an
*] easy way to accomplish this inside of mySQL.
*]
What are the requirements for 'random' and 'unique'? Do you need some sort
of cryptographic randomness? Does
*] I need to generate a RANDOM UNIQUE number for every new record.
Is
there an
*] easy way to accomplish this inside of mySQL.
*]
What are the requirements for 'random' and 'unique'? Do you need some
sort
of cryptographic randomness? Does uniqueness be kept across tables?
On Wed, May 23, 2001 at 02:22:02PM -0400, Dave Carter spake thusly:
*] I need to generate a RANDOM UNIQUE number for every new record. Is there an
*] easy way to accomplish this inside of mySQL.
*]
The way I do this for session ids is through a perl function that I
wrote a long time ago.
*] I need to generate a RANDOM UNIQUE number for every new record. Is there an
*] easy way to accomplish this inside of mySQL.
*]
The way I do this for session ids is through a perl function that I
wrote a long time ago. Essentially I create a really long string of
mixed case alpha
Message-
From: clay bond [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 19, 2001 6:51 PM
To: [EMAIL PROTECTED]
Subject: Re: Advice needed
On Sat, 19 May 2001, Dave Carter wrote:
I'm converting an Access db to mySQL, and Access allows users to Insert
Records into a table AND call them
On Sat, 19 May 2001, Dave Carter wrote:
I'm converting an Access db to mySQL, and Access allows users to Insert
Records into a table AND call them as well in the FROM clause. This is
illeagal in ANSI SQL however and therefore illeagal in mySQL, but I don't
know really how to get around it.
On 19-May-01 Dave Carter wrote:
I'm converting an Access db to mySQL, and Access allows users to Insert
Records into a table AND call them as well in the FROM clause. This is
illeagal in ANSI SQL however and therefore illeagal in mySQL, but I don't
know really how to get around it. How can I
On 3/27/01 4:54 PM, "WeAreUs" [EMAIL PROTECTED] wrote:
Hi!
I enter some .wav encoded (windows) data into a MySql table as follows:
$data = addslashes(fread(fopen($form_data, "r"),
filesize($form_data)));
$result=MYSQL_QUERY("INSERT INTO
Assuming you have table staff with an id and name,
and title with id and title,
You create a join table.
Staff_id Title_id
1 1
1 2
2 1
2 3
Then:
Select name,title
FROM staff s , title t, jointable j
WHERE s.id=j.staff_id AND j.title_id=t.id;
Mark Worsdall wrote:
you need a join table between the two tables. It would contain the primary
keys of both tables. This way for any given staffID, you could have 0-n
records that contain staffId subjectTitles_id.
To get all the subjectTitles for a given staff you would
Select * from staff_subjectTitles where
You are building a "many to many" relationship.
How to do it:
* Each staff member should have an unique ID (eg StaffMember_ID) in the
Staff table;
* Each subject has an ID in the SubjectTitles table;
* and you need a third table, with two fields: StaffMember_ID and
SubjectTitle_ID, plus extra
Hi,
Thanks for all the advice, one question, the create a JOIN table, you
mean just create a table, is the naming convention for join tables
something like:-
join_jobTitles
In other words prefix all join tables with join_?
M.
In message [EMAIL PROTECTED], Gerald L. Clark
[EMAIL PROTECTED]
54 matches
Mail list logo