Bug #23135 Slow views performance

• Submitted: 10 Oct 2006 12:10
• Modified: 10 Oct 2006 13:39
• Reporter: Nuno Soares
• Status: Duplicate
• Category: MySQL Server
• Severity: S5 (Performance)
• Version: 5.0.19
• OS: Linux (Linux)
• CPU Architecture: Any
• Tags: performance, Views

[10 Oct 2006 12:10] Nuno Soares

Description:
Views have slow performance on tables with large amount of data (my base table has 30000 rows and it's growing very fast).

create view v1 as
select c1, c2, c3, sum(c4) as total
  from t1
 group by c1, c2, c3

when i run the query
select * from v1 where c1 = 1
the execution time is 0.4500s

and

select c1, c2, c3, sum(c4) as total
  from t1
 where c1 = 1
 group by c1, c2, c3
the execution time is 0.0032s

what can i do to improve the view execution time ?

How to repeat:
select * from v1 where c1 = 1

select c1, c2, c3, sum(c4) as total
  from t1
 where c1 = 1
 group by c1, c2, c3

[10 Oct 2006 13:39] Valeriy Kravchuk

Duplicate of bug #23136.