I think you need to give us the SQL you are using to do the search - we'll ba ble to see what your are trying to do better Alan
> -----Original Message----- > From: 笛 短 [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 17 October 2002 15:37 > To: [EMAIL PROTECTED] > Subject: a mysql question > > > 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