On Wed, Mar 28, 2012 at 4:19 PM, Paul McNett <[email protected]> wrote: > On Mar 28, 2012, at 14:12, Stephen Russell <[email protected]> wrote: > >> >> Prod table count = 27,385 >> >> New version 33,095 > > Pretty sure someone is doing it wrong. ------------------
This is a very large app. They append a company number into a table name to identify the owner of this information. We have multiple companies, ten so far, so each table that is part of the database will have in our case 10 tables for the various information. It makes it easy to separate our UK data from our CA data as well as our USA data. I didn't make the rules up I just got hired here 4 months ago and live with what is on the plate. -- Stephen Russell 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMY+UNw3jYYYQLZfJggsxPLLxaHTiKgaY3Q7M-T2rDUW_=a...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

