InnoDB or BDB?

2004-04-06 Thread Victor Medina
Hi all! I am currently developing a small pos (point of sale) application. The pos will run on linux and will use java and mysql. I best guess, is that only one client will access the db during normal operations. I would like to know wich, in your opinion, should be the best option to use. The

Re: InnoDB or BdB

2002-07-03 Thread Jeremy Zawodny
On Wed, Jul 03, 2002 at 02:37:16PM -0700, Michael Ivanyo wrote: > Hello, > > My perception of the InnoDB vs BDB question is that although the BDB > is very impressive and long standing, it does not get the same level > of attention that InnoDB seems to get from the good folks at MySQL > AB. If I

Re: InnoDB or BdB

2002-07-03 Thread Michael Ivanyo
Hello, My perception of the InnoDB vs BDB question is that although the BDB is very impressive and long standing, it does not get the same level of attention that InnoDB seems to get from the good folks at MySQL AB. If I am not mistaken, BDB does not yet offer foreign key support. I have chosen

RE: InnoDB or BdB

2002-07-03 Thread Cal Evans
Subject: InnoDB or BdB Heey There Folks, Well, I hope that this message gets through finallly. First I got it back from the deamon because I had send it in html format, then because of I was suspected from spamming this list. Only for not having used the words query or sql once ... well, I have n

InnoDB or BdB

2002-07-03 Thread Wouter van Vliet
Heey There Folks, Well, I hope that this message gets through finallly. First I got it back from the deamon because I had send it in html format, then because of I was suspected from spamming this list. Only for not having used the words query or sql once ... well, I have now so it should come th

Re: Newbie question: Which is better InnoDB or BDB?

2002-05-27 Thread Benjamin Pflugmann
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 comment

Newbie question: Which is better InnoDB or BDB?

2002-05-23 Thread Richard Davidson
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? Is there a sign

InnoDB or BDB & ON DELETE RESTRICT

2002-04-17 Thread Yurais Fernandez Leal
If I create a table like this: CREATE TABLE depts ( ID Int AUTO_INCREMENT PRIMARY KEY, name VARCHAR(30) ) TYPE=InnoDB; I add three Records to this table. THen I create this other table: CREATE TABLE employees( ID INT AUTO_INCREMENT PRIMARY KEY, name varchar(20), dept_id INT, FOREIGN