I know that www.yahoo.com uses it somewhere... but I can't remember where I read that
(probably on this list a while ago)
- Original Message -
From: "Anthony R. J. Ball" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 30, 2001 12:48 PM
Subject: Need examples of companies
Does anybody know if this amount of memory usage is normal? (taken from *top*)
PID USER PRI NI SIZE SWAP RSS SHARE LC STAT %CPU %MEM TIME COMMAND
677 root 90 19228 0 18M 15801S 0.0
2.1 0:07 mysqld
679 root 9
A mistake I made for a long time with MATCH AGAINST is to not include it in the WHERE
clause
eg I did
SELECT ID,MATCH Q,A AGAINST ("This") AS Score FROM faq
instead of
SELECT ID,MATCH Q,A AGAINST ("This") AS Score FROM faq WHERE MATCH Q,A AGAINST ("This")
The latter will give much better
-
From: "Noor Dawod" [EMAIL PROTECTED]
To: "Jason Terry" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, February 13, 2001 9:23 AM
Subject: RE: TEXT's are giving us headaches!
Hi
Hmm, this seems to me like redundant code.. if you're holding info in
Score, and not usi
Just a side note... you can do JOINs on tables from different databases on the same
mySQL server
eg
SELECT t1.UserName FROM db1.table AS t1, db2.anothertable AS t2 WHERE t1.UserName =
t2.UserName
As for database layout... I would go with what makes the most sense... If having 84
tables in
I have a need for a SELECT query...
I don't really want any of the data from the select...
Rather I need the size of the data
basically I need
SELECT sum(length(*)) FROM MyDB WHERE MyDB.Something LIKE 'this%'
-
Before
