Hi, As the entries grows in mysql database in linux intel box, the time taken to search(select statement) for entries increases linearly. But, when the entries grows in mysql DB, the time taken to update entries is constant. Why is it constant at update as entries grows ? Updates includes search for entry first and update the entry next. So the time has to be linear since search is the part of update. Can some one help me out why is the update time constant insted of linear as entries grows? Is mysql doing any optimization for update operations? Pls help me out.
Thanks in advance, Battini Chandra Sekhar, Digital India, Bangalore. --------------------------------------------------------------------- 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
