Post #199,412
3/18/05 2:05:37 PM
|
The "Multi-Generational Architecture"...
...of [link|http://firebird.sourceforge.net/|Firebird], as well as its closed-source ancestor [link|http://www.borland.com/interbase/|InterBase], makes that problem moot for those two.
WTF is he gibbering about, you ask? Here, read this [link|http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_conf_opt#Multi_generational|explanation of Multi-Generational Architecture].
[link|mailto:MyUserId@MyISP.CountryCode|Christian R. Conrad]
(I live in Finland, and my e-mail in-box is at the Saunalahti company.)
Your lies are of Microsoftian Scale and boring to boot. Your 'depression' may be the closest you ever come to recognizing truth: you have no 'inferiority complex', you are inferior - and something inside you recognizes this. - [link|http://z.iwethey.org/forums/render/content/show?contentid=71575|Ashton Brown]
|
Post #199,582
3/20/05 5:52:19 AM
|
More commonly known as MVCC
Multi Version Concurrency Control
[link|http://www.postgresql.org/docs/7.4/static/mvcc.html|http://www.postgresq.../static/mvcc.html]
[link|http://www.google.com/search?client=safari&rls=en-us&q=mvcc+database&ie=UTF-8&oe=UTF-8|http://www.google.co...ie=UTF-8&oe=UTF-8]
I continue to be amazed at mysql's popularity given its limitations and the availability of postgres.
"Whenever you find you are on the side of the majority, it is time to pause and reflect" --Mark Twain
"The significant problems we face cannot be solved at the same level of thinking we were at when we created them." --Albert Einstein
"This is still a dangerous world. It's a world of madmen and uncertainty and potential mental losses." --George W. Bush
|
Post #199,606
3/20/05 1:41:46 PM
|
You'd be amazed
Ever seen a large application (backed by MySQL in this case) where every query used exclusively left joins? Guess why? The guy deciding what db server to use only knows one join syntax, and it's LEFT JOIN. Doesn't grasp the performance issues. Doesn't care about the fact that it potentially returns different data. (You can always add "DISTINCT" to the SELECT clause.)
Oh, and doesn't see the need for triggers, stored procedures, or referential integrity constraints, because "real programmers" take care of all that stuff in their code.
Yes, he actually puts down anyone wishing for referential integrity checks as just being lazy. Woo!
(Nah, we don't find corrupt data on a near-daily basis. Why do you ask?)
===
Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats].
[link|http://DocHope.com|http://DocHope.com]
|
Post #199,627
3/20/05 6:20:17 PM
|
MySQL Gotchas
[link|http://sql-info.de/mysql/gotchas.html|MySQL Gotchas] scary stuff. Here's another that isn't on that list (yet?): Update ... limit ... [link|http://dev.mysql.com/doc/mysql/en/update.html|MySQL update syntax]. The where clause specifies n rows, the limit says (n-x), so x rows aren't updated and you have no way to know which ones. How is that ever a good idea?
Have fun,
Carl Forde
|
Post #199,643
3/20/05 9:39:19 PM
|
My favorite quote:
6. Oh yes, this page does not render well in Internet Explorer, run along and get yourself a proper browser. -- [link|mailto:greg@gregfolkert.net|greg], [link|http://www.iwethey.org/ed_curry|REMEMBER ED CURRY!] @ iwethey[link|http://it.slashdot.org/comments.pl?sid=134485&cid=11233230|"Microsoft Security" is an even better oxymoron than "Military Intelligence"] No matter how much Microsoft supporters whine about how Linux and other operating systems have just as many bugs as their operating systems do, the bottom line is that the serious, gut-wrenching problems happen on Windows, not on Linux, not on Mac OS. -- [link|http://www.eweek.com/article2/0,1759,1622086,00.asp|source]
|
Post #199,942
3/22/05 2:06:32 PM
|
Somebody's channeling Peter in 'snarky' mode.
|
Post #199,661
3/21/05 12:46:21 AM
|
That postgres link is really useful.
It is very close to the MaxDB documentation. Hmm. I'm getting the idea that multi-versioning databases are letting themselves get walked over by MySQL.
Wade.
Is it enough to love
Is it enough to breathe
Somebody rip my heart out
And leave me here to bleed
| |
Is it enough to die
Somebody save my life
I'd rather be Anything but Ordinary
Please
| -- "Anything but Ordinary" by Avril Lavigne. |
|
Post #199,666
3/21/05 1:16:06 AM
|
mysql
is the answer to that complex problem of data storage that is obvious and simple and wrong.
"Whenever you find you are on the side of the majority, it is time to pause and reflect" --Mark Twain
"The significant problems we face cannot be solved at the same level of thinking we were at when we created them." --Albert Einstein
"This is still a dangerous world. It's a world of madmen and uncertainty and potential mental losses." --George W. Bush
|
Post #199,699
3/21/05 9:14:29 AM
|
That is the question *I* keep asking MySELF.
Why MySQL? Doesn't really work well.
PostgresQL scales much better and can manage much more data with fewer resources.
-- [link|mailto:greg@gregfolkert.net|greg], [link|http://www.iwethey.org/ed_curry|REMEMBER ED CURRY!] @ iwethey[link|http://it.slashdot.org/comments.pl?sid=134485&cid=11233230|"Microsoft Security" is an even better oxymoron than "Military Intelligence"] No matter how much Microsoft supporters whine about how Linux and other operating systems have just as many bugs as their operating systems do, the bottom line is that the serious, gut-wrenching problems happen on Windows, not on Linux, not on Mac OS. -- [link|http://www.eweek.com/article2/0,1759,1622086,00.asp|source]
|
