Sorry, but it is hard to understand what you are actually asking, but I'll try.
If you are returning too large resultset, it is possibly a JDBC driver problem, since it will retrieve all into Java objects, which could take "forever". If you know your SELECT statement, just issue it in the mysql client, and you will know the number of records returned as well as how long it takes. But I think you are trying to say something about multi-threading on connections. If I am not mistaken, you are not allowed to re-use the same connection with more than one query at a time. You either need an exclusion mechanism or a connection pool to distribute available connections among "users", i.e. different threads. Niclas On Thursday 17 October 2002 13:36, 笛 短 wrote: > I'm a chinese software engineer, and I has use mysql > for three years ago.Now,I get a matter from it. > recently,I'm deal big data use mysql first.every > table's data is one million,so user search the data > will use long time.now ,if some user search one table > togeter,the table is dead , and I find the connection > to the mysql cann't close,my God,I only restart it. > > my develop language is JAVA.But I can't think the > error is in JAVA code.my question is wheather mysql > can't support a lot of connection search one table > together? > > I want get a help or an advance for you ,thanks. > > _________________________________________________________ > Do You Yahoo!? > 新鲜到底,娱乐到家 - 雅虎推出免费娱乐电子周报! > http://cn.ent.yahoo.com/newsletter/index.html > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
