Re: VARCHAR -vs- CHAR: huge performance difference?

Dear C. Bensend wrote:

>   I am parsing and storing emails, so I have a lot of character string
>data to worry about.  In one particular table, I have 26 columns of type
>varchar, with widths of 24-8192 characters.  This is the table that is
>giving me some pretty severe performance problems.
>
>   For example, many of the statistics I run against these emails is a
>simple count(), whether it be on a column or *.  Right now, counting the
>rows takes in excess of 3.5 seconds.  OK, that's pretty slow.  However,
>there are only --> 24,000 <-- rows in this table!  I could see it taking
>a long time if I had 500,000 rows, or a million, but 24,000?
>
>
>
For similar  post someone suggested to do a count like

select count(*)  from table where any = any limit 1 ;

Try this look if thiers any  performance increase.

--
Regards,
Vishal Kashyap
Director / Lead Software Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Yahoo  IM: mailforvishal[ a t ]yahoo.com