> -----Original Message----- > From: Seena Blace [mailto:[EMAIL PROTECTED] > Sent: den 11 maj 2005 23:58 > To: mysql@lists.mysql.com > Subject: table optimisation > > Hi, > I have been noticing table performanace issue when # of rows > grows more.How to tune that table?
Adding index on the column or columns that are often used in queries could be a start. Performing full table scan on large, unindexed tables can take quite longtime when the number of rows are increasing. /Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]