Hello,
Please suggest the best way to customize a set of queries to use different
tables (but same columns).
For example, let's say that I have a humongous amount of customers and the
DBA decided to split into tables by continent. Let us also assume that
there will be 7 distinct subcomponents
To be honest in the first place I'd ask DBA to use partitioning if your db
engine supports that, and if not, to create union USERS query to run my
queries against.
I thought you can pass table names dynamically using a $table_name. My best
bet would be to create the table name at your dao layer and pass it as a
param to the query.
On Thu, Aug 21, 2008 at 11:31 AM, Nicholoz Koka Kiknadze [EMAIL PROTECTED]
wrote:
To be honest in the first place I'd ask