On Tue, Mar 05, 2002 at 01:04:50PM +0530, Battini, Chandrashekar wrote: > Hi, > > As the entries grows in mysql database in linux intel box, the time > taken to search(select statement) for entries increases > linearly.
If that's true, you may need to use an index to speed up the query. This article may help: http://www.linux-mag.com/2001-06/mysql_01.html > 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? Upates or inserts? If a select is slow, the corresponding update should be slow too, unless one is using an index and one is not. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 25 days, processed 866,467,873 queries (389/sec. avg) --------------------------------------------------------------------- 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
