List:General Discussion« Previous MessageNext Message »
From:Thomas Sundberg Date:May 12 2005 6:37am
Subject:RE: table optimisation
View as plain text  
> -----Original Message-----
> From: Seena Blace [mailto:sqlserverdb@stripped] 
> Sent: den 11 maj 2005 23:58
> To: mysql@stripped
> 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

Thread
table optimisationSeena Blace12 May
  • RE: table optimisationThomas Sundberg12 May
  • Re: table optimisationGleb Paharenko12 May
RE: table optimisationSeena Blace12 May
  • Re: table optimisationPeter Brawley12 May