Re: subquery performance

2006-09-25 Thread Jeff Drew
Thanks for the detailed feedback. I do not create the data so I can't modify it. Your illustration of the table is correct. I'll try to implement some of your feedback. Thanks On 9/25/06, Michael Stassen <[EMAIL PROTECTED]> wrote: Jeff Drew wrote: > I have a query wi

subquery performance

2006-09-25 Thread Jeff Drew
I have a query with a subquery which does not throw an error, but does not return either. I've been testing the query using mysql Query Browser and the poor dolphin jumps only once a minute or so ;) I use MYSQL's excellent error documentation heavily so if the query doesn't throw an error, I'm

stuck on localhost authentication

2006-08-05 Thread Jeff Drew
I'm apologize for posting an apparently simple question, but I'm stuck. I'm trying to get my java application to connect to mysql on the same server. The server is redhat with mysql 5.1.11. I'd done this with mysql 4.x in the distant past. I add a user with the command: insert into user (user

sporadic batch update problem

2005-12-04 Thread Jeff Drew
Sporadically, the last few entries of a batch are not written. I'm writing to a mysql database using JDBC. Here's a short version of my code. Does anyone have suggestions on possible causes or other diagnostics? class DatabaseWriter{ int writeCount=0; public DatabaseWriter(){ PreparedStat

optimal number of connections?

2005-04-15 Thread Jeff Drew
Our Java application has several threads that use JDBC to write to several tables. Currently, we use one JDBC connection. Would performance improve if we used a connection per table? Is a single connection bad for some reason? Since connection pooling is a hot topic, I'm wondering if we're mis

changing the datadir on .rpm SuSE install?

2005-04-09 Thread Jeff Drew
Can the the datadir be changed with a .rpm install on SuSE? Our SA gave us a large partition on /export. We installed the .rpm and were running fine with the datadir set to the default /var/lib path. So I need to move the datadir to /export. Since we're just moving to Production, we do not ne