Placed At : MAATDLN
Govind Raghuram@SATYAM 12/31/2002 02:50 PM Hi, I am trying to do an update query - update bb_activeamtbalance set ui_orgbalance = "+orgbalance+",ui_remainingbalance ="+rembalance+",ui_usedcurrently="+usedbal+",ui_upddatetime=now(),ui_timeusedcurrently ="+timeused+",ui_currentprodcode='"+product+"',ui_expirydate='"+exptime+"' where ui_userid='"+userid+"' I find this query in the slow query list. This query succeeds once in 3 times and when it hangs...I find that if I do a flush tables then the query succeeds again for some number of times and then the problem reoccurs. I am trying to figure what could be the cause...can someone help me with this. I am invoking this query through a java program using org.gjt.mm.mysql.Driver. Raghu --------------------------------------------------------------------- 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