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 Flu
able be a
"majority rules" type of decision?
Thank you again 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
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 Ash
ng 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]> wr
rceFields: id=1, name="Author", ...
sourceRequireds: id=1, type=1, field=1; id=2, 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 wro
ut!) would be
appropriate here?
If possible, maybe a general "conventional wisdom" statement would greatly
help my education on these matters!
Thank you,
Jeffrey Santos
1:55 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
ctober 10, 2005 1:26 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
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 t