Hi.
I have the following test db/tbl setup.
stateTBL
+--+
| stateName|
| stateID |>>>+
+--+ V
V
V
collegeTBL V
+--+ V
| collegeName | V
| stateID |<<<+
| college
Sometimes people need a good kick up the arse, and take Widenius's post as just
that; a good thing. Rather that than loads of bugs, denial and silence, that we
always see from the closed source databases.
--- On Tue, 9/12/08, Daevid Vincent <[EMAIL PROTECTED]> wrote:
> From: Daevid Vincent <[E
http://developers.slashdot.org/article.pl?sid=08%2F12%2F09%
2F0047225&from=rss
Sun's Mickos Is OK With Monty's MySQL 5.1 Rant
"Back on November 29, MySQL developer Michael Widenius trashed Sun's
decision to give MySQL 5.1 a 'generally available' designation in a
now-infamous blog post. Widenius
Hmmm, no. That's not it. The 2 queries using if() return the right
number of rows. The union return too few.
Anyway. I ended up with a query that runs in about 1 sec. compared to
the original that ran about 3 min. I'm happy :)
Thanks a bunch.
On Tue, December 9, 2008 14:53, Thomas Pundt wrote:
>
Götz
We've been doing this for some time. Of course we have GigE internally so
the network is not a problem. The biggest problem for us is making sure the
students know to configure software they want to use for their web sites to
use the MySQL server name rather than the default which is usually
'
Hi,
over the last couple of years our infrastructure rose as we needed and
now we are thinking about the next steps as the access to the servers grows.
Currently we run a couple of Red Hat EL 5.x LAMP systems (e.g. our
webserver, a webmail system, an application server) on 64 Bit hardware
(mostly
On Dienstag, 9. Dezember 2008, Mogens Melander wrote:
| I can't figure out why the "UNION" solution is missing 4 rows. I'll include
| the 3 complete statements, so maybe someone smarter than me can figure out
| why there's a difference in the result.
Without having "studied" your query, my guess w
Thanks for the suggestions.
My original query returned 5784 rows in 184.89 sec. Brent Baisley's variant
returned 5784 rows in 1.34 sec. and Peter Brawley's solution resulted in
5780 rows in 1.46 sec. I'm officially impressed :)
I can't figure out why the "UNION" solution is missing 4 rows. I'll i
