Re: JDBC J/Connect driver is seriously slow against InnoDB

2002-11-04 Thread Mark Matthews
j.random.programmer wrote: Mark: Once of the great things about MySQL is the prompt attention and response on this list. Thanks for replying to this email so quickly. Read on... No problem! --- Mark Matthews wrote: >j.random.programmer wrote: > >>Hi: >> >>Thought I'd mention this (using t

Re: JDBC J/Connect driver is seriously slow against InnoDB

2002-11-04 Thread j.random.programmer
Mark: Once of the great things about MySQL is the prompt attention and response on this list. Thanks for replying to this email so quickly. Read on... --- Mark Matthews <[EMAIL PROTECTED]> wrote: > j.random.programmer wrote: > > Hi: > > > > Thought I'd mention this (using the latest dev > > J/co

Re: JDBC J/Connect driver is seriously slow against InnoDB

2002-11-03 Thread Mark Matthews
j.random.programmer wrote: Hi: Thought I'd mention this (using the latest dev J/connect): A) DatabaseMetaData.getColumns() does not return the last 4 columns (SCOPE_*) but it should according to the API spec I'll look into fixing this right away. You should write Sun as well, as their JDBC c

JDBC J/Connect driver is seriously slow against InnoDB

2002-11-03 Thread j.random.programmer
Hi: Thought I'd mention this (using the latest dev J/connect): A) DatabaseMetaData.getColumns() does not return the last 4 columns (SCOPE_*) but it should according to the API spec B) InnoDB, on their benchmark page, say that inserting 100,000 rows into the DB is about 5 seconds. http://www.i