Re: Inno DB Question

2002-09-03 Thread Heikki Tuuri
Javier, - Original Message - From: "Javier Diaz" <[EMAIL PROTECTED]> To: "'Heikki Tuuri'" <[EMAIL PROTECTED]> Cc: "[EMAIL PROTECTED] (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, September 03, 2002 12:32 PM Subject: RE: Inno D

RE: Inno DB Question

2002-09-03 Thread Javier Diaz
')"); Conn->ExecuteDirect("COMMIT"); But I don't know why is impossible to do the same using the normal TSQLQuery. I already sent the message to the borland newsgroups. Thanks Javier -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: 02

Re: Inno DB Question

2002-09-02 Thread Heikki Tuuri
abase.mysql Sent: Monday, September 02, 2002 3:06 PM Subject: Inno DB Question > Hi all, > > I'm using MySQL 4.0.2 alpha-max with Inno DB and Borland Builder 6.0 to > connect to MySQL. I'm trying to use the new dbExpress component for Borland > to connect to MySQL using the

RE: Inno DB Question

2002-09-02 Thread Javier Diaz
w for the ODBC connection is working fine, but the same code using TSQLQuery (dbExpress Component) dosen't work. Do you have any idea what can be the reason? Thanks Javier -Original Message- From: Tod Harter [mailto:[EMAIL PROTECTED]] Sent: 02 September 2002 15:58 To: Javier Diaz Subjec

Inno DB Question

2002-09-02 Thread Javier Diaz
Hi all, I'm using MySQL 4.0.2 alpha-max with Inno DB and Borland Builder 6.0 to connect to MySQL. I'm trying to use the new dbExpress component for Borland to connect to MySQL using the libmysql.dll I have been making some tests with transactions using the dbExpress components and the normal ODB

Re[2]: Inno DB question

2001-07-19 Thread BAUMEISTER Alexandre
Stanislav, HT> I have a question about using InnoDB format of tables with MySQL. HT> We have a following problem: HT> our application collects data into MySQL database during some period of time HT> (say 1 hour) and then we need to analyze these data then move insert results HT> of analysis into

Re: Inno DB question

2001-07-19 Thread Heikki Tuuri
Stanislav, how big is the insert and update load to your table? One user of InnoDB says that it copes with his average load of 800 inserts/updates per second. The computer has 4 processors. Since InnoDB has the non-locking consistent read, SELECT queries do not stop inserts or updates to your t

Inno DB question

2001-07-19 Thread Stanislav Dmitrenko
G'day, I have a question about using InnoDB format of tables with MySQL. We have a following problem: our application collects data into MySQL database during some period of time (say 1 hour) and then we need to analyze these data then move insert results of analysis into other table within same