Skip navigation links

MySQL Forums :: Performance :: Varchar length - performance


Advanced Search

Varchar length - performance
Posted by: Sakis Terzis ()
Date: June 28, 2013 03:40AM

I am running some queries of the type SELECT * WHERE myvarchar LIKE '%something%'
The database uses myIsam and the Varchar has now fixed length 8000

Does the length of that field plays any role in the performance?
If i use joins in the query does the length affects the performance?

Options: ReplyQuote


Subject Views Written By Posted
Varchar length - performance 724 Sakis Terzis 06/28/2013 03:40AM
Re: Varchar length - performance 361 Rick James 06/29/2013 03:00PM
Re: Varchar length - performance 320 Sakis Terzis 07/01/2013 01:59AM
Re: Varchar length - performance 442 Rick James 07/02/2013 03:24AM
Re: Varchar length - performance 283 Sakis Terzis 07/03/2013 02:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.