IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / It's not an InnoDB table.
Post #199,855
by static
3/21/05 6:46:33 PM
Reply
New It's not an InnoDB table.
And I can't change it. Everything in the database is MyISAM; partly because that's the default. Besides, the server doesn't have InnoDB turned on, and the table requires a FullText index (which isn't supported on InnoDB).

I'm getting the impression that the loud and popular "free" database, MySQL, is still several years behind practically everyone else. Including the other "free" database, PostGres. I don't think The Powers That Be will be at all interested in changing the database. :-/

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,895
by CRConrad
3/22/05 2:57:24 AM
Reply
New "Including 'THE' other..." ?!? :-(
If you're beginning to think it's ridiculous that so many people think of MySql as "THE" free database... then imagine how much "better" it is to imply that there is just ONE *other* free database.

(The most ironic thing about this is that PostGres, too, is just an upstart compared to [link|http://firebird.sourceforge.net/|Firebird]/[link|http://www.borland.com/interbase/|Interbase]; the latter began life at about the same time as, or even before, Oracle.)


   [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,901
by static
3/22/05 6:17:56 AM
Reply
New Quite.
However, when the un-knowledgeable look for a "free" database, their first two choices are usually MySQL then PostGreSQL. As I've just unwittingly demonstrated. :-)

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,916
by JayMehaffey
3/22/05 9:43:49 AM
Reply
New That would be a problem.
MyISM is really only sutible for setting up a single user / single computer database. MySQL has been focusing on InnoDB based databases, since that is the database version that is transaction safe.

I'm getting the impression that the loud and popular "free" database, MySQL, is still several years behind practically everyone else. Including the other "free" database, PostGres. I don't think The Powers That Be will be at all interested in changing the database. :-/

MySQL is popular because it is fast and easy, but it is least SQL compliant of the popular databases. MySQL 5 seems to move it up a lot terms of SQL compliance and adds some key features, but I have not had a chance to play with it much. MySQL's popularity is really grounded in the fact that many low cost web hosting companies support nothing but MySQL.

Jay
     Simplistic Database locking. - (static) - (19) - March 18, 2005, 01:15:11 AM EST
         AFAIK, Oracle is the only one using its model -NT - (ben_tilly) - (2) - March 18, 2005, 01:47:50 AM EST
             Postgres allows it too -NT - (broomberg) - (1) - March 18, 2005, 06:38:29 AM EST
                 Does it now? - (static) - March 18, 2005, 07:01:52 AM EST
         Re: Simplistic Database locking. - (JayMehaffey) - (6) - March 18, 2005, 09:40:45 AM EST
             The SELECT does. - (static) - (5) - March 21, 2005, 12:49:10 AM EST
                 Re: The SELECT does. - (JayMehaffey) - (4) - March 21, 2005, 09:16:52 AM EST
                     It's not an InnoDB table. - (static) - (3) - March 21, 2005, 06:46:33 PM EST
                         "Including 'THE' other..." ?!? :-( - (CRConrad) - (1) - March 22, 2005, 02:57:24 AM EST
                             Quite. - (static) - March 22, 2005, 06:17:56 AM EST
                         That would be a problem. - (JayMehaffey) - March 22, 2005, 09:43:49 AM EST
         The "Multi-Generational Architecture"... - (CRConrad) - (8) - March 18, 2005, 02:05:37 PM EST
             More commonly known as MVCC - (tuberculosis) - (7) - March 20, 2005, 05:52:19 AM EST
                 You'd be amazed - (drewk) - March 20, 2005, 01:41:46 PM EST
                 MySQL Gotchas - (cforde) - (2) - March 20, 2005, 06:20:17 PM EST
                     My favorite quote: - (folkert) - (1) - March 20, 2005, 09:39:19 PM EST
                         Somebody's channeling Peter in 'snarky' mode. -NT - (inthane-chan) - March 22, 2005, 02:06:32 PM EST
                 That postgres link is really useful. - (static) - (2) - March 21, 2005, 12:46:21 AM EST
                     mysql - (tuberculosis) - (1) - March 21, 2005, 01:16:06 AM EST
                         That is the question *I* keep asking MySELF. - (folkert) - March 21, 2005, 09:14:29 AM EST

And from the spring collection, tablizer is wearing a simple three-table combination here, which offsets the index tables beautifully, whilst still preserving the relationships.
107 ms