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 > a