The MyISAM table type should be fine for what you are doing, and is faster than the InnoDB type. Basically, you only need transactions in situations where a) money is involved or b) you will be updating multiple tables and all updates must be guaranteed successful, or none.
hth, Arthur ----- Original Message ----- From: "John Chang" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 14, 2002 7:51 AM Subject: Type > 1) Is there a de facto type that is used? All I will be doing is creating > a database for use on the web for dynamic webpages. Basically doing > searches to the back-end MySQL database. I figure I don't need to use > transactional type since I will not be adding any information via a > front-end. I will probably load a file whenever I need to add more > data. Am I correct? Or is it always best to use a transactional > type? And which transactional type is better/reliable/robust to use? > > 2) If later on I change my mind and create a webpage as the front-end and > start inputing data this way will I need a transactional type? > > Thank you. > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
