Hello
Perhaps you can show me the right direction in the great opportunity.
I have about 3 or 4 tables which are basically template tables, as our data grows we actually copy these template table to create other tables. For example:
(template table) – Invoice_Template
(dynamic table) – Invoice_0601 (January 2006 invoices)
(dynamic table) – Invoice_0606 (June 2006 invoices)
(dynamic table) – Invoice_Customer200 (Invoices for customer 200)
The above are simple examples, please note the relations, fields, and other attributes are all copied from the _Template table. I would like to use the LLBLGen Pro to handle our system, and I believe the adapter approach would be flexible enough to handle this, but since the tables are create dynamically in code. When LLBLGen Pro runs the tables are not there, therefore no reference to it exists yet. What would be your recommendation in approaching this opportunity? I was thinking in the following approaches:
- Using the power of partial and basically overloading the adapter class, however I am under the impression this would not be a easy thing to do.
- Using the power of the LLBLGen Pro tool to create those dynamic adapters automatically, but I do not know if LLBLGen Pro has this capability.
- Using another way to approach my problem of huge data storage.
For you to have a perspective on how much data I am talking about we could, in a big customer installation, be talking about 14M records a day, for a particular table.
Please let me know, and thank you in advance.
Bruno Valle
