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
env
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
> -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
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: 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 m
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 impleme
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
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 ta
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 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
topic_d
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
[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 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
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
---
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 comfortabl
--- 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?"
> >
]
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 sh
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 pu
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 she
e: -
To: "Peter J Milanese" <[EMAIL 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
-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
-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 slig
> -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
>
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 (as
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 th
rd Dudlik
Becoming Digital
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
er 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 im
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:
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;
+-+--++
> 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
On 01-Jun-2003 Daniel Crompton wrote:
>
> 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
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 PROTECTED]
>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 ar
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 respon
-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 risk
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 th
* 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 mus
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 ques
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 clien
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 ran
> > > > *] 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
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 randomne
> > *] 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 'onl
> *] 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 al
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. Essen
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 AN
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 ca
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
Hi!
It;s been a while since i used Access, so i can't remember exactly
what you mean. But for what you've said you probably have three
choises:
1) Create a primary key, try to insert a record with already
existing
key and fail. Failure means that record already exists. Nothing
special.
2)
There is an option long_query_time that you can use to log query that
take longer then a preset time, if that's of any help.
cheers,
roel
On Sat, Apr 07, 2001 at 02:05:13PM +0100, Ewan Birney wrote:
>
>
> We are very happy users of MySQL, which we run a nice big genome database
> on. We hav
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
> b(audio,filename,filesize,file
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 da
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 sta
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:
>
>
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 PROTECTE
56 matches
Mail list logo
