MySQL :: Re: Paasing Table name to Query from another Table in stored procedure

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: Paasing Table name to Query from another Table in stored procedure

Posted by: Barry Galbraith
Date: January 28, 2013 12:16AM

>So If i put them together it is taking so much time to generate report for second company even if it has 2000 records.

Really?!

That's what RDBMs eat for breakfast!
Properly indexed. millions of rows is not a problem.

>Please suggest any workaround i can do to overcome this problem.

Build proper RDBS tables instead of spreadsheets.

Good luck,
Barry.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

Paasing Table name to Query from another Table in stored procedure

Manthan Tripathi

January 26, 2013 07:38AM

Re: Paasing Table name to Query from another Table in stored procedure

Barry Galbraith

January 27, 2013 06:10PM

Re: Paasing Table name to Query from another Table in stored procedure

Manthan Tripathi

January 27, 2013 11:50PM

Re: Paasing Table name to Query from another Table in stored procedure

Barry Galbraith

January 28, 2013 12:16AM

Re: Paasing Table name to Query from another Table in stored procedure

Manthan Tripathi

January 28, 2013 04:59AM

Re: Paasing Table name to Query from another Table in stored procedure

Barry Galbraith

January 28, 2013 02:45PM

Re: Paasing Table name to Query from another Table in stored procedure

Rick James

January 27, 2013 10:04PM

Re: Paasing Table name to Query from another Table in stored procedure

Manthan Tripathi

January 27, 2013 11:53PM

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.