Rene,
How are you querying the database during normal use? What kind of
applications are you using?
~Jeffrey Santos
On Mon, Sep 22, 2008 at 2:46 PM, Rene Fournier [EMAIL PROTECTED] wrote:
Uptime: 1054977 Threads: 10 Questions: 15576766 Slow queries: 229
Opens: 489 Flush tables: 1 Open
here?
If possible, maybe a general conventional wisdom statement would greatly
help my education on these matters!
Thank you,
Jeffrey Santos
, type=2, field=1, ...
Thank you again for your help!
~Jeffrey Santos
On Wed, Sep 17, 2008 at 7:19 AM, Kevin Hunter [EMAIL PROTECTED] wrote:
At 5:46am -0400 on Wed, 17 Sep 2008, Jeffrey Santos wrote:
I'm developing an application
that will require information from various sources. Since what
to have repeated instances of, for example, Author
fields under the different source types. Which becomes more problematic?
The JOIN overhead or the repetition of similar data?
Thank you,
~Jeffrey Santos
On Wed, Sep 17, 2008 at 11:21 AM, Martin Gainty [EMAIL PROTECTED] wrote:
Good Morning
Joins
required
fields such as Author, Title, ... etc. A website, on the other hand,
would also require fields such as URL and Date Visited and so on and so
forth.
I hope that's more clear!
~Jeffrey Santos
On Wed, Sep 17, 2008 at 9:57 AM, David Ashley [EMAIL PROTECTED] wrote:
On Wed, Sep 17, 2008
for your response,
~Jeffrey Santos
On Wed, Sep 17, 2008 at 12:47 PM, Geert-Jan Brits [EMAIL PROTECTED] wrote:
Hi Jeffrey,
David already gave a lot of valid points.
Table-per-documenttype seems the way to go here.
As to the 'best' db-scheme for your task given your description you have to
ask
Hey all!
I'm a very novice MYSQL user of the mentality of get it working, then get
it working the right way, feeling the best way to learn is to just do it.
I got things working but now I'm looking back and trying to get better
efficiency out of my SQL statements.
Database is setup like
PM
To: Jeffrey Santos
Cc: mysql@lists.mysql.com
Subject: Re: UPDATE statement optimization
Jeffrey Santos [EMAIL PROTECTED] wrote on 10/10/2005 01:07:03 PM:
Hey all!
I'm a very novice MYSQL user of the mentality of get it working, then get
it working the right way, feeling the best
PM
To: Jeffrey Santos
Cc: mysql@lists.mysql.com
Subject: RE: UPDATE statement optimization
Unless you are on a severely underpowered machine, MySQL will handle 3
million rows without any problems. If you are on such an underpowered
machine, then your current process must absolutely CRAWL