RE: Performance Improvements with VIEW

2013-07-30 Thread Rick James
t kind of things are you doing? If Data Warehouse 'reports', consider Summary Tables. Non-trivial, but the 'minutes' will become 'seconds'. > -Original Message- > From: Bruce Ferrell [mailto:bferr...@baywinds.org] > Sent: Tuesday, July 30, 2013 7:08 A

Re: Performance Improvements with VIEW

2013-07-30 Thread Bruce Ferrell
On 07/30/2013 04:13 AM, Manivannan S. wrote: Hi, I've a table with 10 Million records in MySQL with INNODB engine. Using this table I am doing some calculations in STORED PROCEDURE and getting the results. In Stored Procedure I used the base table and trying to process all the records in the

Re: Performance Improvements with VIEW

2013-07-30 Thread Andrew Moore
I think you're reducing the amount of rows referenced throughout the proc using the view. This might be where you're seeing a performance difference. If you create an innodb table where the structure and row count match the view maybe you'll see another difference? I'll wait for Rick James' input b

Performance Improvements with VIEW

2013-07-30 Thread Manivannan S.
Hi, I've a table with 10 Million records in MySQL with INNODB engine. Using this table I am doing some calculations in STORED PROCEDURE and getting the results. In Stored Procedure I used the base table and trying to process all the records in the table. But it's taking more than 15 Minutes to