in reply to database design question
Assuming you have multiple feeds per client, the meta data on each client would be stored in a "client" table that has a structure like this.
clientID, feedID, viewName,FormatFlag, ...You should hire a DBA or really dig into some basic relational principles. Too often, developers with little or no experience in relational data base management architect themselves into a corner by not understanding key concepts like rationalization.
A good DBA would have a structure outlined for you in half a day or less complete with optimized indexes.
|
|---|