Re: Use of MySQL with large tables

2001-09-25 Thread Kevin Kotun
We have a table with over 27 Million rows and have had trouble with the JDBC with large queries. Our solution has been to use loops with a more restrictive where clause. Its not mission critical so I have not investigated very sincerely. But I recently ran across the --quick option for the

Re: Use of MySQL with large tables

2001-09-23 Thread Arjen G. Lentz
Hi Stephen, - Original Message - From: Stephen Faustino [EMAIL PROTECTED] We are encountering two issues when using MySQL with large tables (by large, we're talking 1 million rows). Our application is written in Java and we are using the mm.mysql JDBC driver. We run our

Use of MySQL with large tables

2001-09-21 Thread Stephen Faustino
We are encountering two issues when using MySQL with large tables (by large, we're talking 1 million rows). Our application is written in Java and we are using the mm.mysql JDBC driver. We run our applications using both Oracle and MySQL. Below are issues that we have experienced. 1. The