On Tue, Apr 7, 2015 at 8:50 AM, Jeff Johnson <j...@san-dc.com> wrote:
> Man-wai, actually I am going to use VFP to scan the tables and see which > ones of them have data in them. Out of 1025 tables, very few are used. > > This is the most bizarre database structure I have ever seen. Nothing is > stored in the primary table except foreign keys to tables. There is a name > table, eye color table, hair color table, etc. > > It was developed by a non-programmer and they kept working on it until > they sold it as a commercial application. It is very expensive also. > > ----- > You have a normalized system I guess. Welcome to the world of intense data instead of simplistic Master with one or two child tables. I have worked with a name table before because it greatly reduces index stress in inserting and when you are searching for last name "Williams" across 4 million rows it is much faster. The text search to find 1 row out of 4000 is instantaneous, and taking it's key value to the other table it increases your search speed by a factor of 12 I found when I put this into SQL Server 2005 system. We had 4-6 million customers as I remember. Customer support was real happy because they could find someone's record without have to wait a while with them on the phone bitching about a charge. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmyjj8d1s3gdwzgh8hdqfg4needwxb4xsf0pevetrkk3...@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.