Posted by Roy Harvey on 08/04/06 13:28

On 4 Aug 2006 01:17:45 -0700, "panic attack" <tunc.ovacik@gmail.com>
wrote:

>partitioning the table is one of the solvation but for our production
>system unfortunately it is not proper for use. :((
>cause we have lots of clients and if we partition the tables for our
>each client there are gonna be enourmus number of tables, so it is not
>possible to deal with those number of tables right now...

The idea was not to partition the table by client, but to normalize it
so that the time periods are rows, not columns (for one example.)

My suggestion is to define multiple staging tables, each with a subset
of the columns. All would have to include the key column(s), then
each would include a different part of the rest. One data import for
each table, of course, selective on columns. Then when the data is
in, JOIN on the keys.

Roy Harvey
Beacon Falls, CT

[Back to original message]