Hello.
On Thu, May 23, 2002 at 11:53:49AM -0400, [EMAIL PROTECTED] wrote:
> Hello,
> I'm new to MySql. I plan to switch my Java/JDBC web application to use
> MySql. The application requires transactions so, as I understand it, I need
> the table types to be BDB or InnoDB. Can anyone offer comments on which file
> type is preferred? Is one more stable than another?
InnoDB is more actively supported.
> Is there a significant difference in speed?
Answers to such statements always depend on your kind of usage.
> I have looked in the manual. One difference I saw was page locking
> versus record locking. At this point, I'm not sure that difference
> is significant.
That's the point. As long as you are not sure about your needs, there
is no reason to bother. Just start with the table type which looks
nicer to you at first glance.
If you should learn that it doesn't fit your needs, the other table
types are only one ALTER TABLE command away.
Regards,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
