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