Same queries, different tables

2008-08-21 Thread Alex O
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

Re: Same queries, different tables

2008-08-21 Thread Nicholoz Koka Kiknadze
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.

Re: Same queries, different tables

2008-08-21 Thread Sundar Sankar
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